Pagination fixes for GraphQL upgrade

What does this MR do and why?

Various fixes to make GraphQL pagination compatible with 2.x

Related to #363131 (closed)

Extracted from !88733 (merged) for easy review

MR acceptance checklist

This checklist encourages us to confirm any changes have been analyzed to reduce risks in quality, performance, reliability, security, and maintainability.

• I have evaluated the MR acceptance checklist for this MR.