4 ms·

SQL is a bad language for writing complex queries. Sometimes need to read inside out or bottom up, etc to make sense of it. Wish duckdb had a more procedural ap

SQL is a bad language for writing complex queries. Sometimes need to read inside out or bottom up, etc to make sense of it. Wish duckdb had a more procedural api.

ok123456 3y ago
CTE solves this problem. I prefer SQL expressions because they're composable. If you want to do things procedurally, you can just bind a result to a dataframe with duckdb.
erikcw 3y ago
How about the Relational API[0] or the new PySpark compatible API[1] added in this release? [0] https://duckdb.org/docs/archive/0.8.1/api/python/relational_api https://duckdb.org/docs/archive/0.8.1/api/python/relational_... [1] https://github.com/duckdb/duckdb/pull/8083 https://github.com/duckdb/duckdb/pull/8083
zX41ZdbW 3y ago
SQL could be friendlier for complex queries. We have recently made a talk on the improvements to SQL to simplify complex expressions: https://www.youtube.com/watch?v=zhrOYQpgvkk https://www.youtube.com/watch?v=zhrOYQpgvkk