Server-side Pagination for SQL Datasources

**Summary:** Add native server-side pagination support for SQL-based datasources (ClickHouse, MySQL, PostgreSQL, etc.) in Table Panel to improve performance when querying large datasets. **Problem Statement:** Currently, Grafana's Table Panel only supports client-side pagination, which requires loading all query results into the browser before paginating. This creates significant performance issues when dealing with large datasets: - **Performance degradation:** Queries returning thousands of rows take too long to load or fail entirely - **Browser memory issues:** Large result sets can crash or freeze the browser - **Database load:** Unnecessary data transfer and processing for records that won't be displayed - **Poor UX:** Users must wait for all data to load before seeing any results Current Behavior: ``` SELECT * FROM table ORDER BY timestamp DESC LIMIT 10000 ``` **Desired Behavior:** ``` SELECT * FROM table ORDER BY timestamp DESC LIMIT 50 OFFSET 0 SELECT * FROM table ORDER BY timestamp DESC LIMIT 50 OFFSET 50 SELECT * FROM table ORDER BY timestamp DESC LIMIT 50 OFFSET 100 ``` **Why It Matters:** - Prevents browser crashes caused by large result sets - Reduces load on the database and network - Significantly improves dashboard usability and performance - Critical for logs, audit trails, security events, and analytical datasets **Proposed Solution:** - Add backend support for page and page_size parameters - Datasource plugins should expose their pagination capabilities (LIMIT/OFFSET, keyset pagination, etc.) - Table Panel should trigger a new query when the user changes pages - Sorting and filtering actions should reset to page 1 **Additional Reference:** Discussion regarding pagination at the datasource level has been raised in the Grafana Community: https://community.grafana.com/t/pagination-at-the-datasource-level/157116 **Conclusion:** Server-side pagination is a critical missing feature for users working with large datasets in Grafana. Implementing this fea…