pagination

Implement cursor-based and offset pagination for APIs. Covers efficient database queries, stable sorting, and pagination metadata.