Closed pcoccoli closed 9 months ago
firepit just passes MATCHES through, but I think we need to use MATCH for SQLite3 (https://www.sqlite.org/lang_expr.html) and ~ for PostgreSQL (https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP)
MATCHES
MATCH
~
firepit just passes
MATCHESthrough, but I think we need to useMATCHfor SQLite3 (https://www.sqlite.org/lang_expr.html) and~for PostgreSQL (https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP)