title: SQLAlchemy and scalar values
body: <p>I have simple question regarding SQLAlchemy, is it possible to get the rows from the result as scalars instead of tuples? In other words I want an equivalent to:</p>
  
  <pre><code>[i[0] for i in self.archive.query(IRTerm.term).distinct()]
  </code></pre>
  
  <p>Thank you</p>