SQL style guide

Re:SQL style guide by r00fus on Monday October 10, 2016 @02:19AM (#12675383)

Re; #1, I also use comma-first indenting and I actually put each field in it's own line specifically for ease in commenting (first_name would have its own line)

[ Parent | on HN ]

Re:SQL style guide by Treffynnon on Monday October 10, 2016 @02:32AM (#12675420)

This doesn't solve the problem at hand either unfortunately. You'll still have a hanging comma in front of `last_name`:

  SELECT 
      -- first_name
       , last_name
       , email_address
    FROM users

When parsed it will look like this query error to the system:

  SELECT
       , last_name
       , email_address
    FROM users

[ Parent | on HN ]