Examples, from the top of my head:
1. JOIN USING, for databases that support it. In some databases you can replace
FROM t1 JOIN t2 ON t1.c1 = t2.c1 AND t1.c2 = t2.c2 ...
FROM t1 JOIN t2 USING (c1, c2)
2. Ability to exclude columns in select *
DuckDB:
SELECT * EXCLUDE (c1)
SELECT * EXCEPT (c1)
Examples, from the top of my head:
1. JOIN USING, for databases that support it. In some databases you can replace
with much shorther and cleaner2. Ability to exclude columns in select *
DuckDB:
Spanner