for example, regular expression matches text ("\w") or number ("\d") :
the "similar to" function has the same issue.
Proper escaping of quotes was not possible in the past for Table API. SQL and SQL Client
were not standard compliant.
FLINK-8301 backslashes were considered in SQL literals, however, they
should only be used in SQL `U&'\1234'` literals. For the Table API, the new
logic relies on the Java/Scala escaping and uses duplicate quotes for escaping
the quotes in expression strings. For SQL, we rely on unicode string literals
with or without the UESCAPE clause. The SQL Client was using backslashes for
escaping new lines. For the SQL Client, we allow unescaped new lines and
use ';' for statement finalization; similar to other SQL clients.