[sqlalchemy] Aliasing a constant within a recursive CTE

I'm trying to use the new CTE support in SQLAlchemy in a way that will allow me to reference the recursion level as a field in the query result. This is easy in a straight SQL CTE by aliasing a constant in the non-recursive part, and then referencing the alias in the recursive part. The limited

Re: [sqlalchemy] Aliasing a constant within a recursive CTE

On Mon, Jul 09, 2012 at 03:12:16PM -0700, Russ wrote: I'm trying to use the new CTE support in SQLAlchemy in a way that will allow me to reference the recursion level as a field in the query result. This is easy in a straight SQL CTE by aliasing a constant in the non-recursive part, and then