Dang, Ibis doesn't support Redshift or SQL Server. I'm also having trouble under... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

starpilot on Nov 5, 2019 | parent | context | favorite | on: What SQL Analysts Need to Know About Python (2016)

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.

goatinaboat on Nov 5, 2019 [–]

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...

philipov on Nov 6, 2019 | [–]

SQLAlchemy is more than just an ORM. It also has sql expression language, for writing queries using python without using any ORM features.

Join us for AI Startup School this June 16-17 in San Francisco!
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact