[Epic] A collection of Substrait conversion issues

### Is your feature request related to a problem or challenge?

This is a follow up on https://github.com/apache/datafusion/issues/15069. A `--substrait-round-trip` flag was added to the sqllogictest runner, which runs the sqllogictest suite with one additional step: when a DataFusion logical plan is produced, it's converted to Substrait and from Substrait back to DataFusion logical before executing it.

This new sqllogictest execution mode has revealed the following issues:

- https://github.com/apache/datafusion/issues/16271
- https://github.com/apache/datafusion/issues/16272
- https://github.com/apache/datafusion/issues/16273
- https://github.com/apache/datafusion/issues/16274
- https://github.com/apache/datafusion/issues/16275
- https://github.com/apache/datafusion/issues/16276
- https://github.com/apache/datafusion/issues/16278
- https://github.com/apache/datafusion/issues/16279
- https://github.com/apache/datafusion/issues/16280
- https://github.com/apache/datafusion/issues/16281
- https://github.com/apache/datafusion/issues/16282
- https://github.com/apache/datafusion/issues/16283
- https://github.com/apache/datafusion/issues/16285
- https://github.com/apache/datafusion/issues/16287
- https://github.com/apache/datafusion/issues/16293
- https://github.com/apache/datafusion/issues/16294
- https://github.com/apache/datafusion/issues/16295
- https://github.com/apache/datafusion/issues/16296
- https://github.com/apache/datafusion/issues/16297
- https://github.com/apache/datafusion/issues/16298

### Describe the solution you'd like

A fix to the mentioned issues so that the sqllogictest in Substrait round-trip mode can run in the CI

Inizia con la modalità --substrait-round-trip del runner sqllogictest e leggi le issue figlie collegate per identificare un singolo errore di conversione. Il lavoro è completato quando i casi di round-trip Substrait elencati hanno esito positivo e questa modalità può essere eseguita in CI.

Scritto dal modello di indicizzazione a partire dal testo della issue.