Adding aliases to WHERE, ORDER BY and GROUP BY clauses