Re:What SQL Analysts Need to Know About Python (2016)
by starpilot on Monday November 04, 2019 @08:56PM
(#21448898)
Dang, Ibis doesn't support Redshift or SQL Server. I'm also having trouble understanding what it really is - it's an entire framework for big data it seems and not just a translator. What I'd really like is just that, something that turns pandas dataframe operation into ANSI SQL. So input pandas2sql('tablename["col"]') -> "select col from tablename". Something really simple to use.
Re:What SQL Analysts Need to Know About Python (2016)
by goatinaboat on Tuesday November 05, 2019 @01:48AM
(#21450257)
Pandas has from_sql and to_sql methods that are compatible with SQLAlchemy if you insist on using an ORM, that gets you most of the way there...
https://docs.ibis-project.org/notebooks/tutorial/2-Basics-Ag...