[Feature][SDK] Transform support REGEXP_...() related functions

[emptyOVO]

Description

• parent issue: #10796
• from flinksql: https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/
• this issue aimed to add support for regex related functions
• include functions below:
  1. REGEXP(string1, string2)--Returns TRUE if any (possibly empty) substring of string1 matches the Java regular expression string2, otherwise FALSE. Returns NULL if any of arguments is NULL.

2. REGEXP_REPLACE(string1, string2, string3)--Returns a string from STRING1 with all the substrings that match a regular expression STRING2 consecutively being replaced with STRING3.

3. REGEXP_COUNT(str, regex)--Returns the number of times str matches the regex pattern. regex must be a Java regular expression. str <CHAR | VARCHAR>, regex <CHAR | VARCHAR> Returns an INTEGER representation of the number of matches. NULL if any of the arguments are NULL or regex is invalid.

4. REGEXP_EXTRACT(string1, string2[, integer])--Returns a string from string1 which extracted with a specified regular expression string2 and a regex match group index integer. The regex match group index starts from 1 and 0 means matching the whole regex. In addition, the regex match group index should not exceed the number of the defined groups.

5. REGEXP_EXTRACT_ALL(str, regex[, extractIndex])--Extracts all the substrings in str that match the regex expression and correspond to the regex group extractIndex. regex may contain multiple groups. extractIndex indicates which regex group to extract and starts from 1, also the default value if not specified. 0 means matching the entire regular expression. str <CHAR | VARCHAR>, regex <CHAR | VARCHAR>, extractIndex <TINYINT | SMALLINT | INTEGER | BIGINT> Returns an ARRAY representation of all the matched substrings. NULL if any of the arguments are NULL or invalid.

6. REGEXP_INSTR(str, regex)--Returns the position of the first substring in str that matches regex. Result indexes begin at 1, 0 if there is no match. str <CHAR | VARCHAR>, regex <CHAR | VARCHAR> Returns an INTEGER representation of the first matched substring index. NULL if any of the arguments are NULL or regex is invalid.

7. REGEXP_SUBSTR(str, regex)--Returns the first substring in str that matches regex. str <CHAR | VARCHAR>, regex <CHAR | VARCHAR> Returns an STRING representation of the first matched substring. NULL if any of the arguments are NULL or regex if invalid or pattern is not found.

Use case

No response

Are you willing to submit PR?

• [X] Yes, I am willing to submit a PR!

Code of Conduct

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

[emptyOVO]

There is also a transform function pr that supports regexps before this issue #10986 so this issue will strengthen relevant functions