From the SQLAlchemy ORM Tutorial:

You can control the names using the label() construct for scalar attributes and aliased for class constructs:

>>> from sqlalchemy.orm import aliased
>>> user_alias = aliased(User, name='user_alias')
>>> for row in session.query(user_alias, user_alias.name.label('name_label')).all(): 
...    print row.user_alias, row.name_label

This seems to be a lot more typing and a lot less readable than the plain class-instrumented descriptors:

>>> for row in session.query(User, User.name).all(): 
...    print row.User, row.name

But it must exist for a reason. How should it be used? What are some good use cases?

Edit
Report