Ordering on table aliases starting with DESC or ASC ends into an invalid query

This is because when using order by, "desc" and "asc" are trimmed not from the proper position, but from the first place where they are encountered.