v.23.4Improvement

Allow Trailing Commas in SELECT Query Expression Lists

Official CH changelog text
Allow trailing commas in expression list of SELECT query, for example SELECT a, b, c, FROM table. Closes #37802. #48438 (Nikolay Degterinsky).
Allows trailing commas in the expression list of SELECT queries, enabling syntax like SELECT a, b, c, FROM table.

Why it matters

This feature improves query writing convenience and readability by permitting trailing commas in SELECT statements. It eliminates syntax errors caused by an extra comma at the end of expression lists, making it easier to modify and maintain SQL queries.

How to use it

Users can simply add trailing commas to the list of expressions in their SELECT queries without causing syntax errors, for example:

sql<br><code>SELECT</code> a, b, c, <code>FROM</code> table<br>

Related resources

PreviousNext