title: Return query with columns from multiple tables in SQLAlchemy
body: <p>I haven't been able to find an answer to this, but I'm sure it must be somewhere.
  My question is similar to this question: <a href="https://stackoverflow.com/questions/6044309/sqlalchemy-how-to-join-several-tables-by-one-query">sqlalchemy: how to join several tables by one query?</a></p>
  
  <p>But I need a query result, not a tuple. I don't have access to the models, so I can't change it, and I can't modify the functions to use a tuple.</p>
  
  <p>I have two tables, <code>UserInformation</code> and <code>MemberInformation</code>, both with a foreign key and relationship to <code>Principal</code>, but not to each other.</p>
  
  <p>How can I get all the records and columns from both tables in one query?
  I've tried:</p>
  
  <pre><code>query = DBSession.query(MemberInformation).join(UserInformation, MemberInformation.pId == UserInformation.pId)
  </code></pre>
  
  <p>but it only returns the columns of MemberInformation</p>
  
  <p>and:</p>
  
  <pre><code>query = DBSession.query(MemberInformation, UserInformation).join(UserInformation, MemberInformation.pId == UserInformation.pId)
  </code></pre>
  
  <p>but that returns a tuple.</p>
  
  <p>What am I missing here?</p>