Some of the most common operators used in filter() method SQLAlchemy equals: query.filter(User.name == 'leela') not equals: query.filter(User.name != 'leela') LIKE: query.filter(User.name.like('%leela%')) IN: query.filter(User.name.in_(['leela', 'akshay', 'santanu'])) # works with query objects too: query.filter(User.name.in_(session.query(User.name).filter(User.name.like('%santanu%')))) NOT IN:…