Re: [Sqlalchemy-tickets] [sqlalchemy] #2796: Labeled subqueries

[sqlalchemy <mi...@zz...>]

#2796: Labeled subqueries
-----------------------------------+------------------------------------
      Reporter:  kvesteri          |      Owner:  zzzeek
          Type:  defect            |     Status:  closed
      Priority:  high              |  Milestone:
     Component:  sql               |   Severity:  no triage selected yet
    Resolution:  worksforme        |   Keywords:
Progress State:  completed/closed  |
-----------------------------------+------------------------------------
Changes (by zzzeek):

 * status:  new => closed
 * resolution:   => worksforme
 * status_field:  awaiting triage => completed/closed


Comment:

 yeah "label" is intended for column expressions.  when you call label() on
 a select(), that turns it into a scalar select that you could embed as a
 subquery in the columns or where clause.   for a from-based subquery, use
 alias.    I wrote some background on column/where/from subqueries at
 http://docs.sqlalchemy.org/en/rel_0_8/glossary.html#term-subquery.

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2796#comment:4>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python