[EPIC] More Subquery support

[alamb]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.

DataFusion supports many types of subqueries (originally tracked via https://github.com/apache/arrow-datafusion/issues/2248). This epic tracks additional features / support

See also the original design document.

• [x] https://github.com/apache/arrow-datafusion/issues/1835
• [ ] https://github.com/apache/arrow-datafusion/issues/123
• [ ] https://github.com/apache/arrow-datafusion/issues/2480
• [ ] #5484
• [ ] https://github.com/apache/arrow-datafusion/issues/3781
• [ ] https://github.com/apache/arrow-datafusion/issues/3725
• [x] https://github.com/apache/arrow-datafusion/issues/3667
• [ ] https://github.com/apache/arrow-datafusion/issues/3417
• [x] https://github.com/apache/arrow-datafusion/issues/2361
• [ ] #6140
• [x] #5808
• [x] #5789
• [x] #5633