How can I use a list , tuple or any iterable in an in clause using the plain sql expression and bindparams.
e.g. engine.execute(sql.expression.text(''' select * from users where id in :ids '''), ids=[1,2,3,4]) what do I need to change to make this work. I tried this, and it generates not sql: engine.execute(sql.expression.text(''' select * from users where id in (:ids) '''), ids='1,2,3,4') Any ideas to make this just work? I would prefer to use the bindparams as above. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.