Awkward syntax — when developing the query, commenting out the final line of the SELECT list causes a syntax error because of how commas are handled, and we need to repeat the columns in the GROUP BY clause in the SELECT list.
There are some SQL varieties that actually allow a hanging comma! Also, the provided examples seem comma-dependent, no?
As someone who writes a ton of analytical SQL, i think this would get super messy for long, complex queries with casting, case statements, windows functions, etc.
Most people just need to learn to write better SQL!
There are some SQL varieties that actually allow a hanging comma! Also, the provided examples seem comma-dependent, no?
As someone who writes a ton of analytical SQL, i think this would get super messy for long, complex queries with casting, case statements, windows functions, etc.
Most people just need to learn to write better SQL!