andygrove opened a new issue, #3770: URL: https://github.com/apache/arrow-datafusion/issues/3770
**Is your feature request related to a problem or challenge? Please describe what you are trying to do.** PR https://github.com/apache/arrow-datafusion/pull/3764 reverts a regression in optimizing subqueries but does so by running `simplify_expressions` a second time, after subqueries have been converted to joins. This is not the ideal solution. **Describe the solution you'd like** `simplify_expressions` should rewrite subqueries instead. This will support all subqueries, not just the ones that can be converted to joins. **Describe alternatives you've considered** None **Additional context** See conversation https://github.com/apache/arrow-datafusion/pull/3764#discussion_r990612019 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: github-unsubscr...@arrow.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
