Re: [Sqlalchemy-tickets] [sqlalchemy] #1068: render 'SELECT foo() AS x .. ORDER BY x' by default

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

#1068: render 'SELECT foo() AS x .. ORDER BY x' by default
--------------------------------+-------------------------------------------
    Reporter:  jek              |       Owner:  zzzeek                
        Type:  enhancement      |      Status:  new                   
    Priority:  high             |   Milestone:  0.5.0                 
   Component:  sql              |    Severity:  no triage selected yet
  Resolution:                   |    Keywords:                        
Status_field:  awaiting triage  |  
--------------------------------+-------------------------------------------
Changes (by zzzeek):

  * priority:  medium => high
  * milestone:  => 0.5.0

Comment:

 just to be clear, we're talking about:

 {{{
 x = func.foo().label('x')
 select([x]).order_by(x)
 }}}

 and not:

 {{{
 select([func.foo()]).order_by(func.foo())
 }}}

 ?

 (do we want `select([func.foo.label('x')]).order_by('x')` to do it ? seems
 the most succinct way....since its 0.5 we're fine changing contract a
 little bit)

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