Document the streaming mode for the SQL API

[electroheadfx]

In the cubeJS api I don't see any cursor method, only offset. I there something similar that cursor ?

https://mithle.sh/the-pagination-dilemma-offset-vs-cursor-part-2/

[paveltiunov]

@electroheadfx Streaming queries support SQL API is WIP. Do you want to use SQL or REST API with cursor?

[electroheadfx]

Hey, thanks for answer, REST API is fine, maybe SQL too.

[paveltiunov]

@electroheadfx You can try it out using CUBESQL_STREAM_MODE=true for SQL API.

[igorlukanin]

Resolved by #8593.

• Row limit
• Streaming mode in the SQL API