title: Querying with joins in sql alchemy and avoiding select all
body: <p>I would like to know wether there is a way to combine joining two tables, and retrieving the two entities only with their relevant columns.</p>
  
  <p>I want to avoid doing a thing such select * after joining two tables and getting only column <code>id</code> from Table A and column <code>address</code> from table B.
  Working with python2.7
  I heard of sqlalchemy feature called <code>with_entities</code>, but not sure how can it be mixed with this kind of join, lets work on this example from <a href="http://docs.sqlalchemy.org/en/latest/orm/tutorial.html" rel="noreferrer">sqlalchemy tutorial</a>:</p>
  
  <pre><code>u, a  = session.query(User, Address).\
                       filter(User.id==Address.user_id).\
                       filter(Address.email_address=='jack@google.com').\
                       first():
  </code></pre>