title: Access all column values of joined tables with SqlAlchemy
body: <p>Imagine one has two SQL tables</p>
  
  <pre><code>objects_stock
  id | number
  </code></pre>
  
  <p>and</p>
  
  <pre><code>objects_prop
  id | obj_id | color | weight
  </code></pre>
  
  <p>that should be joined on <code>objects_stock.id=objects_prop.obj_id</code>, hence the plain SQL-query reads</p>
  
  <pre><code>select * from objects_prop join objects_stock on objects_stock.id = objects_prop.obj_id;
  </code></pre>
  
  <p>How can this query be performed with SqlAlchemy such that all returned columns of this join are accessible?
  When I execute</p>
  
  <pre><code>query = session.query(ObjectsStock).join(ObjectsProp, ObjectsStock.id == ObjectsProp.obj_id)
  results = query.all()
  </code></pre>
  
  <p>with <code>ObjectsStock</code> and <code>ObjectsProp</code> the appropriate mapped classes, the list <code>results</code> contains objects of type <code>ObjectsStock</code> - why is that? What would be the correct SqlAlchemy-query to get access to all fields corresponding to the columns of both tables?</p>