WHERE clause character delimit specifier for sqlite

[Former user]

Without a special clause, sqlite provides no way to search for the '%' and '_' characters. The following query is supported by sqlite3, but isn't supported by sqlalchemy.

select * from signals where signal_range like '%\%%' escape '\';

The ESCAPE clause configures the specified character to be a delimiting character. Currently, sqlite does not default and requires the ESCAPE clause to set the delimiter.

[Mike Bayer]

seems to be working in 0cc04e6e1b70abc4817f275a898aa063da3de007. example:

table.select().where(table.c.somecol.like('something %\\%%', escape='\\'))

[Mike Bayer]

Removing milestone: 0.4.xx (automated comment)