strings with embedded single quotes not being parsed

[Dave Stokes]

Inserting a string like "O'Connor" or "David's" returns a Fatal Parse Error in vtable mode in DMLParser.

UPDATE foo SET last_name to 'O'\'Malley' WHERE id=123;
or
UPDATE foo SET last_name to 'O''Malley' WHERE ID=123;

The above statements should both escape the single quote in the string as per traditional MySQL string escape and insert O'Malley in filed.