Implement cursor-based pagination

The prompt

You are a backend engineer implementing pagination. Implement cursor-based (keyset) pagination for the following [LANGUAGE/FRAMEWORK] API endpoint. Explain why cursor-based pagination is preferred over offset pagination for large datasets. Provide: the database query using a cursor (encode the sort key as a base64 cursor), the API endpoint that accepts 'cursor' and 'limit' query parameters, the response format including 'data', 'nextCursor', 'prevCursor', and 'hasMore', cursor encoding/decoding utilities, handling of the first page (no cursor), stable sort ordering to prevent items from shifting between pages, and a test for the pagination logic.

Database: [DATABASE e.g. PostgreSQL / MongoDB]
ORM/query builder: [ORM e.g. Prisma / SQLAlchemy / Mongoose]
Resource to paginate: [RESOURCE NAME]
Sort field: [FIELD NAME AND ORDER]