SQLAlchemy's tuple_ construct

gistfile1.py

"""
Assuming a model and table "Thingy" with columns type and id (I love generic association tables,
so you will see this a lot in schemas I write).

While this seems like a headache for multigets, there is a very easy way to do an IN operation on such a table using SQL tuples (index obviously needs to be on both columns for it to be fast):

SELECT * FROM thingy WHERE (type, id) IN (('foo', 1), ('bar', 2));

And SQLAlchemy has a great construct for just this case...
"""

from sqlalchemy.sql.expression import tuple_

Session.query(Thingy).filter(tuple_(Thingy.type, Thingy.id).in_([('foo', 1), ('bar', 2)])).all()