Friendlier SQL with DuckDB
Lots of great additions. I will just highlight two:<p><i>Column selection</i>:<p>When you have tons of columns these become useful. Clickhouse takes it to the next level and supports APPLY and COLUMN in addition to EXCEPT, REPLACE which DuckDB supports:<p><pre><code>    - APPLY: apply a function to a set of columns
    - COLUMN: select columns by matching a regular expression (!)
</code></pre>
Details here: <a href="https://clickhouse.com/docs/en/sql-reference/statements/select/#select-modifiers" rel="nofollow">https://clickhouse.com/docs/en/sql-reference/statements/sele...</a><p><i>Allow trailing commas</i>:<p>I can't count how many times I've run into a problem with a trailing comma. There's a whole convention developed to overcome this: the prefix comma convention where you'd write:<p><pre><code>    SELECT
      first_column
      ,second_column
      ,third_column
</code></pre>
which lets you easily comment out a line without worrying about trailing comma errors. That's no longer necessary in DuckDB. Allowing for trailing commas should get included in the SQL spec.