[paulddraper]

I universally use column positions in the GROUP BY.

  SELECT name, count(*)
  FROM account
  GROUP BY 1

That is still annoying, but requires less typing+modification.

[code_runner]

i go back and forth on this a lot, but with fewer and fewer "in production" SQL queries in my life, number based group by is definitely my default