[Feature] Impl the function `regexp_count` like trino

[HappenLee]

Search before asking

• I had searched in the issues and found no similar issues.

Description

regexp_count(string, pattern) → int
Returns the number of occurrence of pattern in string:

SELECT regexp_count('1a 2b 14m', '\s*[a-z]+\s*'); -- 3

Related issues

#48203

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[felixwluo]

pick