[FEATURE] Pagination with NESTED function in v2 #1718
Description
Is your feature request related to a problem?
NESTED function is not supported in pagination in V2, because NestedOperator (a PhysicalPlan node) adds rows to the result set and cannot be properly paged with the current implementation of Pagination feature.
What solution would you like?
Support NESTED with pagination if it is ever possible.
At least, support single NESTED function, which does not produce cartesian products (extra rows).
What alternatives have you considered?
N/A
Do you have any additional context?
#1500 (comment)