Hacker News Reader

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.

View on HN

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

Or the fact I can join between Excel, MySQL and Postgres. That absolutely a killer feature.

Reply on news.ycombinator.com