sqlglot removes options from the regexp_replace function

[rzykov]

Hey, I have a problem. Sqlglot removes options from the regexp_replace function when translating from a Postgres script to a duckdb one.

Fully reproducible code snippet

sqlglot.transpile("select regexp_replace('mr .', '[^a-zA-Z]', '', 'g')", read="postgres", write="duckdb")[0]
"SELECT REGEXP_REPLACE('mr .', '[^a-zA-Z]', '')"

Official Documentation
DuckdDb regexp_replace https://duckdb.org/docs/sql/functions/regular_expressions.html#using-regexp_replace
Postgres: https://www.postgresql.org/docs/current/functions-matching.html#:~:text=The%20regexp_replace%20function%20provides%20substitution,be%20given%20in%20any%20case.)

[rzykov]

Thank you so much!