Spark-compatible CAST operation

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

We're looking to use DataFusion as a replacement for Spark for some workflows, through Spark -> Substrait -> DataFusion conversions. Lot of the functionality already works, and it's been nice to see DataFusion and Spark agree on most behavior we've tested so far. However, one place where we're seeing more differences is the CAST expression, for example on casting complex types into strings (, or casting strings into numbers (where Spark is more lenient).

One option I've considered is to use [Comet's cast](https://github.com/apache/datafusion-comet/blob/main/core/src/execution/datafusion/expressions/cast.rs), which I'd expect to be closer aligned with Spark (or at least on the way there). However, is there a way for me to replace/redirect the inbuilt Cast expression into using the Comet implementation?

Or would there be any other alternatives I could try?

### Describe the solution you'd like

_No response_

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Inizia leggendo Comet's core/src/execution/datafusion/expressions/cast.rs e confrontalo con il comportamento integrato di CAST di DataFusion. Determina se CAST può essere reindirizzato o sostituito, concentrandoti sulle conversioni da tipi complessi a stringhe e sulle conversioni permissive da stringhe a numeri; il lavoro è completato quando esistono un approccio concreto supportato e un comportamento compatibile con Spark.

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