filter and sqlalchemy code example

Example 1: sqlalchemy filter or

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

Example 2: sqlalchemy filter by relationship

patients = Patient.query.filter(Patient.mother.has(phenoscore=10))