PostgreSql Dialect add regular expression operators

[griffio]

Description

Add regex operators to support Text Searching, that work with new index support in #5124

POSIX regular expressions provide a more powerful means for pattern matching than the LIKE and SIMILAR TO operators.

https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP

Four operators that return boolean, work with TEXT data type

text ~ text → boolean
text ~* text → boolean
text !~ text → boolean
text !~* text → boolean

SELECT *
FROM Test
WHERE text ~ ?;

Can be implemented the same way as the JSON operators in #5100