Add helper for paginating database query results with cursor-based navigation

[Chucks1093]

Summary

The wallet holdings, activity feed, and key holders endpoints all need cursor-based pagination. Each currently implements pagination logic independently. A shared pagination helper that accepts a query builder, page size, and cursor should be used across all list endpoints.

Scope

• Add a paginateQuery(query, { cursor, limit }) helper that appends cursor filtering and limit to a query
• Returns { data, nextCursor, hasMore }
• Add unit tests for: first page with no cursor, subsequent page with cursor, last page where hasMore is false

Acceptance Criteria

• First page returns correct data and a valid next cursor
• Subsequent page using the cursor returns the correct next slice
• Last page returns hasMore: false and no next cursor
• Helper is reusable across different query types

ETA: 12 hours

---

Coordinate on Telegram

[Tobiloba0]

@Tobiloba0 has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi maintainer, can I work on this issue please?

ℹ️ Repo Maintainers: To accept this application, review their application or assign @Tobiloba0 to this issue.

[anoncon]

@anoncon has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

Hi
I’d like to work on this issue if it’s available. I’m a full-stack Web2 & Web3 developer with solid open-source experience and can start working on it right away.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @anoncon to this issue.

[grantfox-oss]

🦊 GrantFox — @anoncon has been assigned to this issue as part of the Official Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #459)
2. Your PR will be reviewed by the accesslayerorg maintainers

Good luck! Track your progress on GrantFox.

[drips-wave]

Congratulations, @anoncon! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @anoncon: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊