%sql charindex issue

[mlkshclk]

When trying to find index of a space between words in a string, CHARINDEX returns wrong result with '%sql' command, but yields the correct result with '%%sql' command:

%sql SELECT CHARINDEX(' ', 'AAA BBB) returns 1.

%%sql
SELECT CHARINDEX(' ', 'AAA BBB) returns 4.

OS: Ubuntu Server 18.04
JupyterLab version: 2.1.5

[EminUZUN]

sql commands produced by magics.