[ENH] DataFusion optimizer enhancements

[andygrove]

Is your feature request related to a problem? Please describe. There are a number of improvements that we can make to DataFusion's optimizer that should benefit Dask SQL.

Describe the solution you'd like

Bugs

• [x] https://github.com/apache/arrow-datafusion/issues/3644
• [x] https://github.com/apache/arrow-datafusion/issues/3646
• [x] https://github.com/apache/arrow-datafusion/issues/3704
• [x] https://github.com/apache/arrow-datafusion/issues/3408
• [x] https://github.com/apache/arrow-datafusion/issues/3390

Enhancements

• [x] https://github.com/apache/arrow-datafusion/issues/3724
• [x] https://github.com/apache/arrow-datafusion/issues/3725
• [x] https://github.com/apache/arrow-datafusion/issues/3667
• [ ] https://github.com/apache/arrow-datafusion/pull/3754
• [ ] https://github.com/apache/arrow-datafusion/issues/3781

Describe alternatives you've considered None

Additional context None