MsSqlServer dialects reject custom SQL Server queries with limits

When retrieving data from SQL Server using a custom SQL query, a NotSupportedException is thrown when the query does not start with SELECT or SELECT DISTINCT. This behaviour prevents the use of paging when using stored procedures. It also prevents the use common table expressions in custom SQL Server queries.