title: SQLAlchemy query tuple values
body: <p>I am trying to display the output of an SQLAlchemy query into a jinja template.
  My query is as follows:</p>
  
  <pre><code>query = db.session.query(models.Server, models.Scan).outerjoin(models.Server.scans).all()
  </code></pre>
  
  <p>The output of which is:</p>
  
  <pre><code>[(&lt;Server u'Testing'&gt;, &lt;Scan u'testscan'&gt;), (&lt;Server u'fasd'&gt;, &lt;Scan u'testscan'&gt;), (&lt;Server u'fdaafas'&gt;, None)]
  </code></pre>
  
  <p>The Server table contains three columns: <code>name, description and ip</code>.<br>
  The Scan table contrain anothe three columns: <code>type, scan_id and timestamp</code>.<br></p>
  
  <p>What I am trying to do is access the servers description and corresponding scan_type.
  I have tried making the query a dict but still cannot access the relevant values. Any help would be great!</p>