from sqlalchemy import text
connection.execute(text(
    'select * from table where string like :string limit 1'), string=
    '_stringStart%')
How to escape % in a query using python's sqlalchemy's execute() and pymysql?