Is your feature request related to a problem or challenge?
The regexp_count() was introduced in PostgreSQL 15 and existed in many similar systems.
Describe the solution you'd like
Implement a new UDF function as other regex_* functions.
Describe alternatives you've considered
No response
Additional context
See discussions related #11946.