Re: [Sqlalchemy-tickets] [sqlalchemy] #2932: textasfrom compatibility with columns, query

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

#2932: textasfrom compatibility with columns, query
------------------------------+-------------------------------
      Reporter:  zzzeek       |      Owner:  zzzeek
          Type:  defect       |     Status:  reopened
      Priority:  highest      |  Milestone:  0.9.3
     Component:  sql          |   Severity:  major - 1-3 hours
    Resolution:               |   Keywords:
Progress State:  in progress  |
------------------------------+-------------------------------

Comment (by zzzeek):

 the same behavior applies to select() too.   this raises an error too,
 meaning from_statement(select()) is also using key_fallback and matching
 on names.   That shouldn't be the case.

 {{{
 #!python
 stmt = select([A.id.label('asdf'), A.data.label('asdfdsa')])
 result = sess.query(A).from_statement(stmt).all()
 }}}

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