Using order by on a distinct query

[olaf-matthes]

I have a query using distinct that is converted to a fetch.xml using distinct='true', so the server does the distinct and all is fine
If I add an order by clause, sql4cds decides to do the distinct on client side, which is a poor idea cause of rows > 500.000 and so hitting retrieval limit

Easy example:
select distinct statecode from contact order by statecode