Comment by rrgok
15 hours ago
Sometimes I prefer DuckDB query language to MySQL or Postgres. It is not even about performance, it just feels right. I just connect to my DBS from DuckDB just to use its query language. And besides it gives you a single language frontend.
This! For example I tried to ask PosgreSQL to Add support for QUALIFY keyword since it makes window queries much more simpler to use. Postgres didnt want it. DuckDB maintainers are always thinking about the DX and all nice syntactic sugar.
The Postgres devs rejected it, because it wasn't part of the standard back then, and apparently work was going on, to include it into the standard.
Now that it's included in the standard, there is work to implement it:
https://hackorum.dev/topics/51960#message-1125429