Projection pushdown on Recursive CTEs with nested subqueries #17853
Description
Is your feature request related to a problem or challenge?
#16696 introduced projection pushdown for recursive CTEs that don't contain a subquery (for simplicity).
Enhance this to support subqueries within the recursive CTE.
Some reference discussion: #16696 (comment)
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response