Closed
Description
Elasticsearch/SQL now supports JDBC/ODBC escape sequences at server level.
However, the current parser requires the {
escape begin character to be followed by the escape discriminator with no white space allowed in-between. Example: FUNCTION_ESC: '{FN';
.
The BNF specification suggests white spaces would be allowed (maybe an ABNF would have made that explicit) and in support for that, other DBs supporting these escape sequences at server level do allow for spaces too (like MSSQL, DB2, MariaDB/MySQL).
Furhermore, also some applications - like PowerBI - generate escape sequences with spaces:
select { fn name(params) } etc.