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:  closed                
    Priority:  medium           |   Milestone:  0.5.xx                
   Component:  sql              |    Severity:  no triage selected yet
  Resolution:  fixed            |    Keywords:                        
Status_field:  awaiting triage  |  
--------------------------------+-------------------------------------------
Changes (by zzzeek):

  * priority:  high => medium
  * status:  new => closed
  * resolution:  => fixed
  * milestone:  0.5.0 => 0.5.xx

Comment:

 the approach here is described in detail in r4999, and is implemented for
 ORDER BY only.  Postgres' behavior was used as the guide here and it seems
 like `order by <some simple label name>` has special meaning versus the
 label name being used in arbitrary expressions or in the WHERE clause.

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