Can't parse some simple queries

[alexeyr]

WHERE cond currently can't depend on derived columns SELECT, while ORDER BY and GROUP BY can't depend on columns not projected in SELECT.