TYPO3 Core

Sidenote: On MSSQL SELECT is processed after GROUP BY - that's the reason alias names cannot be used here.

To be complete ;)

DBMS evaluate statements in the following order:
FROM
WHERE
GROUP BY
HAVING
SELECT
ORDER BY

DBMS with additional logic may be able to resolve aliases set in SELECT in other parts already, but to be safe we should write statements as though there is no additional logic.

Patch set 1 for branch TYPO3_8-7 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/54308