conn.execute('insert into test (data) values (%s)', [(1,), (2,), (3,), (4,),
    (5,)])
result = conn.execute('select * from test where data in %s', (((1, 2, 3),),))
print(result.fetchall())
SQLAlchemy raw SQL parameter substitution with an IN clause