There is an issue with using sort parameter in restAPI against a Microsoft SQL Server Backend. The issue is that the sort query uses a non SQL Server Syntax that causes an error on sort.
ORDER BY t0.ID ASC NULLS FIRST
NULLS FIRST from my understanding is a Oracle syntax.