I'd really be interested in defining a system that covers WITH / RECURSIVE entirely, and makes sense both with PG / SQL server as well as Oracle. The work here is figuring out what is common about those two approaches and what an API that is meaningful for both would look like. Implementation and tests are just the grunt work here.
On Jul 8, 2010, at 2:03 PM, Mike Lewis wrote: > I'd be interested in prototyping a WithClause or something similar if > you think it might be useful. > > I imagine it would have similar semantics to a FromClause but would be > prepended to the query. Currently, I'm not too interested in > prototyping the RECURSIVE part and only care about Postgres. > > For me to implement this would it be possible to do this in a non- > intrusive manner (outside of modifying core SA code?) I'd guess it > would have similar semantics to how select() will automatically > include FromClauses that for columns that reference them. > > Also, it would probably chain the WITHs automatically too. > > Any thoughts? > > Thanks, > Mike > > On Jul 6, 4:31 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: >> this is the current status of that: >> >> http://groups.google.com/group/sqlalchemy/browse_thread/thread/c20a4f... >> >> WITHand OVER seem to be the upcoming things we'll have to work on (PG, >> MSSQL, DB2 supportWITH). Oracle makesWITHdifficult. Its also getting to >> be time to do a DB2 dialect. >> >> On Jul 6, 2010, at 7:07 PM, Mike Lewis wrote: >> >> >> >>> Does SA support this syntax? >> >>> http://www.postgresql.org/docs/9.0/static/queries-with.html >> >>> Thanks, >>> Mike >> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To post to this group, send email to sqlalch...@googlegroups.com. >>> To unsubscribe from this group, send email to >>> sqlalchemy+unsubscr...@googlegroups.com. >>> For more options, visit this group >>> athttp://groups.google.com/group/sqlalchemy?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
