In order to achieve a single parameter affecting a group of items, the statement would have to be modified at the string level before being passed to the database. The single parameter would need to be expanded into the appropriate number of question marks, and the list of parameters would need to be expanded to suit the values. That or, render the values into the string SQL directly. In the latter case you need to be extremely careful to guard against SQL injection and this is the main reason SQLAlchemy itself tries to avoid shipping features like this in the first place.
For SQL processing you can likely use the before_cursor_execute() event to make the changes you want. See http://docs.sqlalchemy.org/en/latest/core/events.html?highlight=before_cursor_execute#sqlalchemy.events.ConnectionEvents.before_cursor_execute . On Nov 3, 2016 11:14 AM, "Chrysovalanto Kousetti" <vala...@gmail.com> wrote: > I mention the issue here: https://bitbucket.org/zzzeek/ > sqlalchemy/issues/3843/in_-operator-does-not-supports-bound. > > > 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? > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
