SQL

sqlalchemy where in query

session.query(MyUserClass).filter(MyUserClass.id.in_((123,456))).all()

sqlalchemy where in query

session.execute(
    select(
        [MyUserTable.c.id, MyUserTable.c.name], 
        MyUserTable.c.id.in_((123, 456))
    )
).fetchall()

where sqlalchemy

query = sqlalchemy.select([actor]).where(actor.columns.first_name == 'PENELOPE')