Problem
The current pagination control for query results is minimal — only a Limit/Offset input with a "Go" button. Navigating large result sets requires manually editing the offset value, which is slow and error-prone.
Proposed solution
Add a richer pagination bar similar to DataGrip:
Page size selector with presets: 5, 10, 20, 100, 500 (default), 1000, All, Custom...
Page navigation with:
- First page / Previous page / Next page / Last page buttons
- Current page indicator with total count (e.g.
1-10 / 501+)
- Click on the page indicator to jump to a specific page
This would make browsing large tables significantly faster and match the workflow users expect from tools like DataGrip / DBeaver / TablePlus.
Alternatives considered
Keep the current Limit/Offset input as an "advanced" option, but expose the page navigation buttons and page size selector as the primary UI.
Problem
The current pagination control for query results is minimal — only a Limit/Offset input with a "Go" button. Navigating large result sets requires manually editing the offset value, which is slow and error-prone.
Proposed solution
Add a richer pagination bar similar to DataGrip:
Page size selector with presets: 5, 10, 20, 100, 500 (default), 1000, All, Custom...
Page navigation with:
1-10 / 501+)This would make browsing large tables significantly faster and match the workflow users expect from tools like DataGrip / DBeaver / TablePlus.
Alternatives considered
Keep the current Limit/Offset input as an "advanced" option, but expose the page navigation buttons and page size selector as the primary UI.