765
765
session.query(User.name).filter(User.name.like('%ed%'))
770
770
query.filter(~User.name.in_(['ed', 'wendy', 'jack']))
774
774
query.filter(User.name == None)
776
776
# alternatively, if pep8/linters are a concern
777
777
query.filter(User.name.is_(None))
781
781
query.filter(User.name != None)
783
783
# alternatively, if pep8/linters are a concern
784
784
query.filter(User.name.isnot(None))
789
789
from sqlalchemy import and_