CODE EXAMPLE FOR SQL

sqlalchemy join on column

db.session.query(User.email).
    join(Account, Account.organization == User.organization).
    filter(Account.name == 'some name')