title: SQLAlchemy Group By With Full Child Objects
body: <p>Imagine the following Media table:</p>
  
  <pre><code>| site       | show_id | time |
  | ---------------------|-------|
  | CNN        | 1       | 'a'   |
  | ABC        | 2       | 'b'   |
  | ABC        | 5       | 'c'   |
  | CNN        | 3       | 'd'   |
  | NBC        | 4       | 'e'   |
  | NBC        | 5       | 'f'   |
  --------------------------------
  </code></pre>
  
  <p>I would like to iterate over query results grouped by show_id and have tried this query:</p>
  
  <pre><code>listings = session.query(Media).filter(Media.site == "CNN").group_by(Media.show_id).all()
  </code></pre>
  
  <p>Here's how I would like to iterate over the results:</p>
  
  <pre><code>for showtimes in listings:
      for show in showtimes:
          print(show.time)
  </code></pre>
  
  <p>But that query doesn't give me all of the grouped child objects.  What am I missing?</p>