News for hackers. Stuff that matters.
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...
Re:What SQL Analysts Need to Know About Python (2016) by philipov on Wednesday November 06, 2019 @03:25AM (#21460651)
SQLAlchemy is more than just an ORM. It also has sql expression language, for writing queries using python without using any ORM features.