Yes, using MS SQL Server (v 19.3).
Is it causing the issue.
I'm also running into an issue with the pagination. The database is MSSQL 2019.
To test the pagination in the UI, I manually changed the limit value in API to 5 (default value for $_GET.limit is 25). The pagination works correctly for the APIs that do not have a nested table in the Paged Query. The pagination doesn't work with a nested table in the Database Paged Query.
I have not created nested query still facing the issue with pagination. Is there an alternate solution that is working for you?
Is the issue due to MS SQL Server?
I have setup the Paged Queries as standard queries. I'm using MSSQL for this project where the pagination is not working when changing the value of limit manually, so it could be an issue with MSSQL.
I haven't setup the pagination with state manager. See if the pagination works without the state manager.