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_

Beginne damit, Comet's core/src/execution/datafusion/expressions/cast.rs zu lesen und es mit dem integrierten CAST-Verhalten von DataFusion zu vergleichen. Ermittle, ob CAST umgeleitet oder ersetzt werden kann, mit Fokus auf Konvertierungen von komplexen Typen in Zeichenketten und nachsichtige Konvertierungen von Zeichenketten in Zahlen; als abgeschlossen gilt die Aufgabe, wenn es einen konkreten unterstützten Ansatz und ein Spark-kompatibles Verhalten gibt.

Vom Indexierungsmodell aus dem Issue-Text verfasst.