Full Support for Positional Arguments in GROUP BY and ORDER BY

Why it matters

This feature allows users to use positional arguments (column positions) in GROUP BY and ORDER BY clauses, improving query writing flexibility by referencing columns by their ordinal positions rather than repeating expressions or column names. It helps simplify queries and enhance compatibility with SQL standards and other database systems.

How to use it

Users can now specify the column positions (e.g., GROUP BY 1, 2 or ORDER BY 1 DESC) directly in their queries without restrictions. Just replace column names or expressions with their respective position numbers in the GROUP BY and ORDER BY clauses.