`in_` operator does not supports bound parameter

[Valanto Kousetti]

This issue is similar to #3574. Using column.in_(bindparam('name')) (to place a variable list of values) throws exception

Unfortunately for me func.any doesn't solve it because I'm using SQLite which does not support ANY. How can I overcome the issue?

[Mike Bayer]

this is a usage question, please use the SQLAlchemy mailing list at https://groups.google.com/forum/#!forum/sqlalchemy.

There should be no reason to send a bound parameter to in_(). Pass a list of literal values and the in_() clause will be expanded at compile time to support the correct number of parameters. there is no other option on SQLite.

[Valanto Kousetti]

Hi Michael, Thanks! I will try the mailing list. I want to apply this in_ filter on relationships so that they apply for every query. The value inside in_() is defined at query time but I need somehow to apply it to all queries like here: https://bitbucket.org/zzzeek/sqlalchemy/wiki/UsageRecipes/GlobalFilter