Explicit Joins in SQLAlchemy

Huang Brandon

The code above will return a list of tuples, where each tuple will have the following structure:

(table_a_col, join_result)

join_results = (
    db.session.query(TableA).filter_by(table_a_col=some_var)
      .join(TableB, TableB.table_a_id == TableA.id)
      .all()
  )