ok, finally getting back to this. Seems to still be an issue and cannot think of why. Here is the error
{“code”:“42000”,“file”:“D:\home\site\wwwroot\dmxConnectLib\lib\db\Connection.php”,“line”:88,“message”:“SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword ‘AS’.”,“trace”:"#0
Sorting and all other functions work great across entire site but anything with pagination has an error and does not work.