Get the latest tech news

How about trailing commas in SQL?


Anecdotally, this might be the most requested feature in SQL: Allow some trailing commas.

But there are loads more places in SQL with comma-separated lists, for example, array constructors, row constructors, function calls, as well as in various commands, such as function definitions, type definitions, COPY, CREATE PUBLICATION, many others. On the SQL side, DuckDB has advertised support for trailing commas, but I have not found rigorous answers to the above questions. Trying it out, they cover some of the popular cases, but you can easily find places where it doesn’t work for no obvious reason.

Get the Android app

Or read this on Hacker News

Read more on:

Photo of SQL

SQL

Photo of commas

commas

Related news:

News photo

SQL or Death? Seminar Series – Spring 2025

News photo

Composable SQL

News photo

Solving complex billable metrics with custom SQL expressions in Lago