v.22.7Improvement

Allow Trailing Comma in Columns List

Allow trailing comma in columns list. closes #38425. #38440 (chen).
ClickHouse now supports trailing commas in column lists for queries and table definitions.

Why it matters

This feature improves the user experience by allowing a trailing comma in the list of columns, which is a common convenience in many SQL dialects. It helps avoid syntax errors when adding or removing columns in queries or table schemas, making code edits simpler and cleaner.

How to use it

Users can simply include a trailing comma at the end of a column list in SELECT statements, table definitions, or other SQL constructs where column lists are specified. No additional configuration is required.