sqlalchemy one to many join code example

Example: sqlalchemy query join many to many

session.query(User).join((Group, User.groups)) \
    .join((Department, Group.departments)).filter(Department.name == 'R&D')