DataGrip Data Editor pagination rewrite with existing LIMIT clause
DataGrip Data Editor supports bounding result sets through a configurable maximum rows to fetch and a per-query limit override, and provides First/Prev/Next/Last navigation with a selectable page size in the result grid. For databases with native LIMIT/OFFSET support, pagination can be implemented by rewriting the query on execution. Fetch size is configurab