SQL Server doesn't support referencing column aliases in ORDER BY clause expressions

[lukaseder]

SQL Server doesn't support referencing column aliases from the SELECT clause in ORDER BY clause expressions. While this works:

select title a
from t_book
order by a asc

This doesn't:

select title a
from t_book
order by a + 'a' asc

jOOQ should prevent aliases from being rendered in ORDER BY clauses for SQL Server.

Other databases may be affected too, e.g. H2 and Derby