Re: [sqlalchemy] Re: Support for Common Table Expressions (CTE)?

2010-07-29 Thread Michael Bayer
oh weird, someone asked about window functions, and I got the two kind of 
confused and responded to that person but not to you.


On Jul 29, 2010, at 6:43 PM, phrrn...@googlemail.com wrote:

> 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"
>  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.
> 

-- 
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.



[sqlalchemy] Re: Support for Common Table Expressions (CTE)?

2010-07-29 Thread phrrn...@googlemail.com
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"
 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.