[Sqlalchemy-tickets] [sqlalchemy] #2753: rewrite strings of same-outered joins to be flat?

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

#2753: rewrite strings of same-outered joins to be flat?
-------------------------+---------------------------------------
 Reporter:  zzzeek       |           Owner:  zzzeek
     Type:  enhancement  |          Status:  new
 Priority:  medium       |       Milestone:  0.9.0
Component:  sql          |        Severity:  minor - half an hour
 Keywords:               |  Progress State:  in queue
-------------------------+---------------------------------------
 i.e.:

 a left outer join (b left outer join c)

 have the compiler reassemble the joins before rendering based on them all
 being "outer" or "inner".

 then, many of the joins that the SQLite compiler turns into subqueries
 won't be so.

 we can always flatten out `a <J> (b <J> (c <J> (...)))`, as long as all J
 are the same, right?   computer scientist in the house?

--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2753>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python