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.