python - SQLAlchemy: selecting which columns of an object in a query

Question

Is it possible to control which columns are queried in the query method of SQLAlchemy, while still returning instances of the object you are querying (albeit partially populated)?

Or is it necessary for SQLAlchemy to perform a SELECT * to map to an object?

(I do know that querying individual columns is available, but it does not map the result to an object, only to a component of a named tuple).

For example, if the User object has the attributes userid, name, password, and bio, but you want the query to only fill in userid and name for the objects it returns:

# hypothetical syntax, of course:
for u in session.query(User.columns[userid, name]).all():
    print u

would print:

<User(1, 'bob', None, None)> 
<User(2, 'joe', None, None)>
...

Is this possible; if so, how?

Answer 1

A simple solution that worked for me was:

users = session.query(User.userid, User.name)
for user in users:
    print user

would print:

<User(1, 'bob')> 
<User(2, 'joe')>
...