Add regexp function - regexp_split_to_array()

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

As discussed in #11946 implement regexp_split_to_array() function

### Describe the solution you'd like

Behavior in https://pgpedia.info/r/regexp_split_to_array.html

### Describe alternatives you've considered

_No response_

### Additional context

Discussed in #11946

Start by reading the discussion in issue #11946 and the referenced pgpedia behavior for regexp_split_to_array(). Then locate the relevant DataFusion SQL function entry point and its tests; done means the function is implemented with behavior matching the reference and covered by tests.

Written by the indexing model from the issue text.