Use fancy-regex instead of regex to support more patterns

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

[fancy-regex](https://github.com/fancy-regex/fancy-regex) is a crate that aims to be a drop in replacement for the standard library [regex](https://github.com/rust-lang/regex) crate, while supporting advanced features like backtracking and look-around. It aims to delegate to the standard library implementation efficiently in cases where the advanced features are not needed.

### Describe the solution you'd like

It would be great if we could optionally use this library in DataFusion's built in regex UDFs.

### Describe alternatives you've considered

- Having two sets of UDFs for each regexp UDF, something like `RegexpReplaceFunc` and `RegexpReplaceFancyFunc` for example.
- Adding a boolean field to these UDFs like `is_fancy`
- Using a compiler feature flag to turn these on across all UDFs

I think the second option is probably the easiest and least intrusive.

### Additional context

_No response_

Inizia individuando le implementazioni integrate delle UDF regex di DataFusion e leggendo come utilizzano attualmente il crate regex standard. Confronta gli approcci proposti per l’integrazione opzionale, quindi definisci il completamento come il supporto di pattern regex avanzati senza interrompere il comportamento esistente delle UDF, con una copertura per il design selezionato.

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