Comment by richbell

1 year ago

IMO having SELECT before FROM is one of SQL's biggest mistakes. I would gladly welcome a new syntax that rectifies this. (Also https://duckdb.org/2022/05/04/friendlier-sql.html)

I don't love the multiple WHEREs.

8 comments

richbell

Duckdb also supports prql with an extension https://github.com/ywelsch/duckdb-prql

SQL was supposed to follow English grammar. Having FROM before SELECT is like having “Begun” before “these clone wars have.”

That's a great list of friendlier sql in DuckDB. For most of that list I either run into it regularly or have wanted the exact fix they have.

duckDB is what sql should be in 2024