It is also possible to filter queries that contain multiple models, including joins: The automatic join is only possible if SQLAlchemy can implictly determine the condition for the join, for example ...