[FEATURE] Paginate system queries in v2

[Yury-Fridlyand]

Is your feature request related to a problem?
Pagination mechanism in V2 should support system queries like SHOW TABLES or DESCRIBE TABLES.

What solution would you like?
Two options here

1. Ignore fetch_size parameter for such queries and always return non-paginated response. V1 works so.
2. Cache entire result set in the cursor and return it paginated.

What alternatives have you considered?
N/A

Do you have any additional context?
N/A

[dai-chen]

I think option 1 makes sense and we can follow V1. Thanks!