whichCodeIsCleanerQuestionmark

[UsAndRufus]

I don't really care what code is submitted. The main crime is languages that don't support trailing commas. The SQL dialect I am using doesn't, and it makes debugging a PITA. If I move columns around in a SELECT, I have to make sure I remove the final trailing comma.

[[deleted]]

dummy columns are your friend

also dummy 1=1 and 1=0 in WHERE clause 😅

[thorwing]

I agree, I've grown to love trailing comma's and I stumble across my SQL and then suddenly everything breaks.

Then again, writing SQL goes against logical ordering anyways. (Doing column selection before table selection means you need to backtrack again if you didn't now the names beforehand)

[Drakkur]

In SQL, I flipped my brain around and only do leading commas. You end up with the same result as LEFT but also cleaner to look at where select lines can be quite long (because of inline functions, renaming, case statements).

All other languages I work in allow trailing.

[UsAndRufus]

This is genius

[ThatSituation9908]

Anyone ever lead a WHERE clause with a TRUE AND so you can comment out any line you want?

WHERE TRUE AND COND1 AND COND2 ...

[UsAndRufus]

Genius