query.filter sqlalchemy code example

Example 1: sqlalchemy filter or

from sqlalchemy import or_
filter(or_(User.name == 'ed', User.name == 'wendy'))

Example 2: sqlalchemy _in array sqlite

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