> for some reason the table comes after its fields I agree it would have been better to start with the FROM clause and have the fields listed near the end.

> for some reason the table comes after its fields I agree it would have been better to start with the FROM clause and have the fields listed near the end. > I write in this style anyway, > using a chain of WITH clauses That sounds like it could make it better. I will try that more often. > the ORDER BY can't be expressed using field aliases > defined at the start of the query In Postgres you can!