[EPIC] Substrait: Additional features for producer and consumer for physical plans

**Is your feature request related to a problem or challenge? Please describe what you are trying to do.**
This is a collection of remaining items for substrait physical plans

**Describe the solution you'd like**
- Create new consumer and producer for physical plans

**Describe alternatives you've considered**

**Additional context**
Substrait to DataFusion's logical plan is tracked at https://github.com/apache/arrow-datafusion/issues/8149

Tasks:
- [ ] https://github.com/apache/arrow-datafusion/issues/9299
- [ ] https://github.com/apache/arrow-datafusion/issues/9347
- [x] https://github.com/apache/datafusion/issues/16590
- [ ] https://github.com/apache/arrow-datafusion/issues/8698
- [x] https://github.com/apache/datafusion/issues/6489
- [x] https://github.com/apache/datafusion/issues/16281
- [ ] https://github.com/apache/arrow-datafusion/issues/8361
- [ ] https://github.com/apache/datafusion/issues/9347
- [ ] https://github.com/apache/datafusion/issues/9299
- [ ] https://github.com/apache/datafusion/issues/10710
- [ ] https://github.com/apache/datafusion/issues/10864

Start by reviewing the unchecked task issues linked in the epic, especially 9299, 9347, 8698, 8361, 10710, and 10864, since no files or tests are identified here. Done means resolving the remaining producer and consumer physical-plan tasks and checking them off this epic.

Written by the indexing model from the issue text.