Feature: support regexp_extract functions

[sundy-li]

Summary

Description for this feature.

regexp_extract(string, pattern[, group = 0])

 regexp_extract('deep_seek', '([a-z ]+)_?', 1);  ---> deep

regexp_extract(string, pattern, name_list)

 regexp_extract('2023-04-15', '(\d+)-(\d+)-(\d+)', ['y', 'm', 'd'])  --->  {'y':'2023', 'm':'04', 'd':'15'}

regexp_extract_all(string, regex[, group = 0])

regexp_extract_all('deep_seek', '([a-z ]+)_?', 1)  --> [hello, world]

reference: https://duckdb.org/docs/stable/sql/functions/regular_expressions.html

[KKould]

assign me

[KKould]

regexp_extract(string, pattern, name_list) This is no longer available in clickhouse. In this case:

SELECT regexp_extract('Color: #FF00BB', '(?P<color>#(\\w{2})(\\w{2})(\\w{2}))', ['color', '2', '3'])

the standard result cannot be verified, do you think this should return {"color": "#FF00BB", "2": "FF", "3": "00"} or {"color": "#FF00BB", "2": "00", "3": "BB"}

Tips: regexp_extract_all also cannot be used, but its meaning is relatively clear

[sundy-li]

Duckdb supports these functions in https://duckdb.org/docs/stable/sql/functions/char.html#regexp_extractstring-pattern-group--0