SyntaxError when using \' in values list about sqlite-parser HOT 2 CLOSED

@philippsimon, according to the SQLite spec, \' is not considered valid string escape sequence.

A string constant is formed by enclosing the string in single quotes ('). A single quote within the string can be encoded by putting two single quotes in a row - as in Pascal. C-style escapes using the backslash character are not supported because they are not standard SQL. - reference

You can get your query to parse correctly by escaping single quotes as '' within a string literal:

INSERT INTO concessions (item, size, id, price)
VALUES ('Lay''s Nachos', 'Regular', null, null),
       ('Pizza', null, 8, 2.00);

from sqlite-parser.

@nwronski thanks! Didn't know that before.

from sqlite-parser.