Example pagination in SQLite:
-- Page 1
SELECT * FROM table_name LIMIT 10 OFFSET 0;
-- Page 2
SELECT * FROM table_name LIMIT 10 OFFSET 10;
-- Page 3
SELECT * FROM table_name LIMIT 10 OFFSET 20;
Will need to find its equivalent representation in SQLAlchemy>=2
.
Logan Connolly referenced this ticket in commit 02b916b.