title: SQLAlchemy convert SELECT query result to a list of dicts
body: <p>When I was using session.query, I was able to convert the result to a list of dicts : </p>
  
  <pre><code>my_query = session.query(table1,table2).filter(all_filters)
  result_dict = [u.__dict__ for u in my_query.all()]
  </code></pre>
  
  <p>But now that I have to work with the <code>SELECT()</code> operation, how can I convert the results to a dict that looks like, for every row result :</p>
  
  <p><code>[{'Row1column1Name' : 'Row1olumn1Value', 'Row1column2Name' :'Row1Column2Value'},{'Row2column1Name' : 'Row2olumn1Value', 'Row2column2Name' : 'Row2Column2Value'},etc....]</code>.</p>
  
  <p>This is my SELECT() code : </p>
  
  <pre><code>select = select([table1,table2]).where(all_filters)
  res = conn.execute(select)
  row = res.fetchone() #I have to use fetchone() because the query returns lots of rows
  resultset=[]
  while row is not None:
      row = res.fetchone()
      resultset.append(row)
  
  print resultset
  </code></pre>
  
  <p>The result is : </p>
  
  <pre><code>[('value1', 'value2', 'value3', 'value4'),(.....),etc for each row]
  </code></pre>
  
  <p>I'm new to Python, any help would be appreciated.</p>