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_

Start by locating DataFusion’s built-in regex UDF implementations and reading how they currently use the standard regex crate. Compare the proposed optional integration approaches, then define completion as supporting advanced regex patterns without breaking existing UDF behavior, with coverage for the selected design.

Written by the indexing model from the issue text.