sqlAlchemy set operations to count code example

Example 1: sqlalchemy _in array sqlite

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

Example 2: except in sql alchemy

u = except_(addresses.select().where(addresses.c.email_add.like('%@gmail.com')), addresses.select().where(addresses.c.postal_add.like('%Pune')))