Goal
Add cursor pagination for large result sets where offset pagination becomes expensive. Should return opaque cursor strings so clients can iterate without exposing row IDs.
Acceptance criteria
query.PaginateCursor(ctx, q, size, cursor) returns {Items, NextCursor, HasMore}- Cursor is opaque (signed base64 of {column, value, direction})
- Works on any orderable column, not just id
- Doc example with API response shape
Goal
Add cursor pagination for large result sets where offset pagination becomes expensive. Should return opaque cursor strings so clients can iterate without exposing row IDs.
Acceptance criteria
query.PaginateCursor(ctx, q, size, cursor)returns{Items, NextCursor, HasMore}