关键需要使用text
from sqlalchemy import create_engine, text
sql = 'SELECT * FROM my_table WHERE account_id = :account_id and amount =: amount' session.execute( text(sql), {"account_id": 100000, "amount": 500} )
传入list
sql_tmpl = "delete from Data where id_data in :iddata" params = { 'iddata':(1, 2, 3, 4), # tuple } self.session.execute(text(sql_tmpl), params)