[sqlalchemy] aliasing a CTE expression

(using sqlalchemy version 7.10 postgres), I'm attempting to join a CTE twice in the same select statement. see here http://www.sqlfiddle.com/#!12/c487e/14 for a SQLFiddle, which shows the full select statement which I'm trying to build but essentially the problem I'm facing is how to create

Re: [sqlalchemy] aliasing a CTE expression

On Jul 15, 2013, at 1:58 PM, Rob robert.sudwa...@gmail.com wrote: (using sqlalchemy version 7.10 postgres), I'm attempting to join a CTE twice in the same select statement. see here for a SQLFiddle, which shows the full select statement which I'm trying to build but essentially the