A somewhat related tip that works in SqlServer (not sure about other dialects) is to put the column alias first rather than at the end of a calculated column. E.g. rather than:

  SELECT
    Foo,
    Sum(Baz) AS Bar
  FROM Quux

Use instead:

  SELECT
    Foo,
    Bar = Sum(Baz)
  FROM Quux

The advantage here is that the names also line up neatly and the shape (column names etc.) of the result is obvious.