Is there an existing issue for the same feature request?

• I have checked the existing issues.

Describe the feature you'd like

1. Define the paginate result API.
   • limit + offset.
2. Implement the paginate function by rerun the query each time.
3. Implement the query result caching function.
4. Using the result caching to implement the paginate function.