Support escape character in string

[StpMax]

select 'a\ b'

String in this query at the moment parsed as is: 'a\ b'
But should be 'a b'

[StpMax]

remind :)

[akshithagunupati]

Hi @StpMax can I work on this?

[ea-rus]

@akshithagunupati, yes, you can try to work on it

[akshithagunupati]

@ea-rus Thank you. But is it possible for you to elaborate on the issue please?

[StpMax]

@akshithagunupati the issue is that mindsdb_sql does not support any escape sequence or escape character. Check examples at the end of this doc page. If run in mysql SELECT 'disappearing\ backslash'; you will get disappearing backslash. But if do the same using mindsdb_sql:

from mindsdb_sql import parse_sql
q = """
SELECT 'disappearing\ backslash';
"""
ast = parse_sql(q, dialect='mysql')
print(ast.targets[0].value)

result will be disappearing\ backslash, which is not correct

[ea-rus]

Added support escaping for quotes in #339

 select 'a \' b'

 select "a \" b"