petehunt/PyMySQL — Issue #86: pymysql should use double quoting instead of backslashes for escaping quotes
Author: Candid
Created: 2011-11-09 16:30:03+00:00
State: open

Currently pymysql uses backslashes to escape quotes. This is not SQL compliant and causes troubles if sql_mode='NO_BACKSLASH_ESCAPES' is set on the server. For example, web2py DAL does that: http://code.google.com/p/web2py/issues/detail?id=488

Instead, it should be using double quoting to escape quotes.