id_list = [1, 2, 3, 4, 5]
s = text('SELECT id, content FROM myTable WHERE id IN :id_list')
conn = engine.connect()
rs = conn.execute(s, id_list=tuple(id_list)).fetchall()
SQLAlchemy raw SQL parameter substitution with an IN clause