I have a function which returns huge number of rows. I need to paginate this data so that I can efficiently render on the UI. I tried to implement using Stored query results. But unfortunately its in preview mode as per the below link, and shouldn't be used in production.
Based on all these restrictions what is the right way to implement pagination without V3 engine or stored query results?
Stored Query Results is the right path to go.
It's not in Preview anymore, it's a mistake in the documentation, and we'll fix it (you'll see the change within a few days). The feature is GA, and you can definitely use it in Production.