Pg_re2: Postgres extension for fast, RE2-powered regular expressions in Postgres (clickhouse.com)

ClickHouse also has vectorscan as a regexp engine, supporting multi- and fuzzy-matching, multi-Volnitsky for substring matching, as well as the new LLVM-JIT compiled regexp engine.