Currently, for regex match operations we have _similar and _nsimilar operators. These are based on Postgres' SIMILAR operator which is based on SQL standard definition of regular expression.

Postgres also has POSIX regular expression which might be more common in usage: https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP

We can add these operators to permissions and graphql schema.