Proposal: Add similar to operator #3016
Description
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Add support for the SIMILAR TO operator like:
string SIMILAR TO pattern [ESCAPE escape-character]
string NOT SIMILAR TO pattern [ESCAPE escape-character]
(This section helps Arrow developers understand the context and why for this feature, in addition to the what)
Describe the solution you'd like
Support this sql syntax where currently users would see a parser error Expected end of statement, found: SIMILAR
Describe alternatives you've considered
There is some overlap between the LIKE operator and SIMILAR though the regex interpretation might be slightly different.
Additional context
Syntax from the postgresql documentation: https://www.postgresql.org/docs/current/functions-matching.html.
Came up while working on tests in the dask-sql project.