`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`.