#373 group and order by using column indexes

[Tom Eugelink]

Is there any chance group and order by are allowed to start using column indexes instead of repeating the expressions that are in the select part? For example: "group by 1,2,3 order by 2".

This makes queries much more compact, more readable and less error prone. In case of the example, if 2 were a calculated field using CASE, that code is present three times.

[Fred Toussi]

It is already possible to use column indexes in ORDER BY.

Aliases for expressions are also supported. They are compact and less error-prone in case you later edit the query. For example:

SELECT MAX(id) m, firstname f, city c FROM customer GROUP by f, c ORDER BY m

[Tom Eugelink]

That is even better. I missed that in the documentation?