Add support for Postgres LIKE operators #8893

Is your feature request related to a problem or challenge?

Add support for the operators ~~, ~~*, !~~, !~~*, which are short-hand for LIKE, ILIKE, NOT LIKE and NOT ILIKE respectively, since they are currently missing.

Describe the solution you'd like

I've opened a sqlparser-rs PR to enable parsing of these tokens into operator enums: apache/datafusion-sqlparser-rs#1096

Ideally we'd then just extend the Operator enum to encompass the new variants, and add evaluation for them like for other binary operators.

Describe alternatives you've considered

Rewriting Postgres queries/ASTs to map the operators into the verbatim LIKE expressions.

Additional context

No response