Progressive Loading for data sourced from external tables using Connect SQL

you can pass the pagination query with Rest or Report Definitions. @taoj1 created a great Constellation 101 on it Infinite Scrolling in Constellation Table for REST API

I’m unaware of the same for Connect-SQL