I see that a ticket has just been opened up on this topic. http://www.sqlalchemy.org/trac/ticket/1859
I will follow up there. thanks, pjjH On Jul 29, 8:33 am, "phrrn...@googlemail.com" <phrrn...@googlemail.com> wrote: > Is there any support yet in SQLAlchemy for Common Table Expressions > e.g. > > WITH foo(blurp, bletch) AS (SELECT bar*2, bletch from banana where > bletch > 3) > SELECT f.* FROM foo as f > where blurp > 1 > > I have not been following SA development for some months (due to a job > move) so I am not yet up to speed with the new yummy @compiles stuff > (which looks like it could certainly help with rolling my own support > for CTEs if it is not already in the core) > > thanks, > pjjH -- 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.