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.