Implement Proposal Read APIs with Pagination

[grantfox-oss]

Description:

Expose governance proposal query surfaces for indexers and UIs.

Tasks:

• Implement get_proposal(id), get_proposal_count(), get_proposals_page(cursor, limit)
• Add limit caps and deterministic ordering
• Add tests for empty, partial, and full-page retrieval

Acceptance Criteria:

Proposal read APIs are deterministic and pagination-tested.

[edehvictor]

GM maintainer

Please I'd love to work on this. I know what to do. I'd quickly submit PR

[EDOHWARES]

Hi Maintainer, I’m interested in this issue. I’ll implement get_proposal, get_proposal_count, and get_proposals_page with deterministic ordering, enforce limit caps, and add tests for empty, partial, and full pages. ETA: 6 hours.