v.24.5Improvement

Allow Trailing Commas in INSERT Query Columns List

Allow trailing commas in the columns list in the INSERT query. For example, INSERT INTO test (a, b, c, ) VALUES .... #63803 (Alexey Milovidov).
Allow trailing commas in the columns list syntax of the INSERT query.

Why it matters

This feature enables users to write INSERT statements with a trailing comma after the last column name in the columns list, improving syntax flexibility and making it easier to modify queries by adding or removing columns without worrying about comma placement errors.

How to use it

Simply add a trailing comma at the end of the columns list in an INSERT query. For example:

INSERT INTO test (a, b, c, ) VALUES ...