News for hackers. Stuff that matters.
Re:I don't need your query language by magicalhippo on Saturday June 17, 2023 @08:52AM (#36369783)
> GROUP BY aliases

We're migrating from Sybase SQLAnywhere to MSSQL, and not being able to use aliases in WHERE, GROUP BY and ORDER BY is such a pain in the behind.

Almost all our non-trivial queries have to be nested multiple levels due to this, which doesn't exactly help readability.

Re:I don't need your query language by bavell on Saturday June 17, 2023 @08:58PM (#36376306)
Ugh, I'll be having to do this same migration soon for one of my clients. Not looking forward to it. Good to know!