Strings with trailing backslashes generate invalid SQL

[stickystyle]

(Might be related to #238)

If you have a string value that ends in an escaped backslash, the query generated will be invalid because it will escape the quoted string in the query.

>>> import pypika
>>> 
>>> table = pypika.Table("a_table")
>>> query = pypika.MySQLQuery.update(table).set(table.column_1, "value_1\\")
>>> print(str(query))
UPDATE `a_table` SET `column_1`='value_1\'

[Cruuncher]

This one is a real gotcha that wouldn't pop up in testing either, and bite you in production

[p-baleine]

I think that Parametrized Queries are utilizable for in such cases.

https://pypika.readthedocs.io/en/latest/2_tutorial.html#parametrized-queries