News for hackers. Stuff that matters.
Re:Best practices for writing SQL queries by ZeroClickOk on Saturday April 10, 2021 @05:19PM (#26765218)
You can easily add remove columns like this, just removing the entire line. If you add the comma the traditional way, you will change 2 lines (the end of previous line with comma, and the new line). It's nice for maintenance and diff'ing
Re:Best practices for writing SQL queries by mulmen on Saturday April 10, 2021 @05:24PM (#26765263)
That is only true of the first or last line.

  col1,
  col2,
  col3

  col1
  ,col2
  ,col3
You can remove col2 from either of those examples and have valid syntax.