title: Select partial entities with specific columns
body: <p>In SqlAlchemy, I need to fetch partial entities with the given list of fields.</p>
  
  <p>Other answers suggest to do any of the following:</p>
  
  <pre><code>session.query(User.id, User.login).all()
  session.query(User).with_entities(User.id, User.login).all()
  </code></pre>
  
  <p>However, SA then returns column tuples:</p>
  
  <pre><code>[ (1, 'user1'), (2, 'user2') ]
  </code></pre>
  
  <p>How do I fetch objects of User instead of tuples and yet limit the retrieved columns?</p>