When they are specified in the SQL statement, the component tries to push LIMIT and OFFSET clauses to the server where possible. However, the maximum supported value for LIMIT is 1000.

Some tables do not offer support for LIMIT and OFFSET clauses. For these tables and when the global search endpoint is hit, these clauses are evaluated client-side.