I'm trying to create a DQL query like that:
This works flawlessly on MSSQL until i try to apply a LIMIT/OFFSET by using setFirstResult() and setMaxResults().
Applying a Limit results in an invoke of "doModifyLimitQuery()" in "Doctrine\DBAL\Platforms\SQLServerPlatform".
The function implementation clearly states what's wrong:
This breaks support with subqueries in SELECT statements.