Is your feature request related to a problem?
A user can send a paginated request with a query which contains features not compatible with pagination. (for example: in memory sorting or aggregation)

What solution would you like?
A new SQL plugin configuration parameter should define how such request should be processed:

1. Return a error
2. Process as a non-paginated request (ignore fetch_size parameter) as it is reported in [BUG] Non-paginated results returned silently if query not supported by cursor #78
3. Fall back to legacy engine ¹²

TODO:

• Define
  • Parameter name and value names
  • Default value
  • Error type for 1
• Implement

What alternatives have you considered?
N/A

Do you have any additional context?
Current behavior: fall back to V1 according to 3