prettier-plugin-sql-cst icon indicating copy to clipboard operation
prettier-plugin-sql-cst copied to clipboard

Add option to toggle trailing commas in SELECT columns list

Open nene opened this issue 2 years ago • 1 comments

Currently the plugin strips trailing commas to enforce a consistent syntax across all SQL dialects. Trailing commas are not part of the SQL standard and are only supported by a few dialects.

However, in dialects that support them (like BigQuery), it's a really nice feature. In other dialects many users resort to using comma-first style to solve the problem for which trailing commas is a much nicer solution.

Something like sqlSelectTrailingComma: "always" | "never" | "preserve". Possibly the "preserve" isn't even needed as it opens a door for inconsistent style.

nene avatar Feb 06 '24 11:02 nene

We are using Oracle in our company and most people like trailing commas (myself included).

chatelao avatar May 26 '25 20:05 chatelao