Re: [sqlalchemy] Extending SQL Alchemy core (0.7.x) with new Select type statement

2013-05-11 Thread Michael Bayer
this syntax is elaborate, as much as a CTE expression, which was a pretty complicated feature add. Anyway, to create an object that has a .c. attribute and which you can select() from, it has to be a FromClause subclass. The columns get filled in using a method _populate_column_collection:

Re: [sqlalchemy] Extending SQL Alchemy core (0.7.x) with new Select type statement

2013-05-11 Thread Michael Bayer
On May 11, 2013, at 11:22 AM, Dan Farmer dfarme...@gmail.com wrote: On Sat, May 11, 2013 at 6:37 AM, Michael Bayer mike...@zzzcomputing.com wrote: Building a custom FROM clause though, a little tricky. Feel free to send along a whole working example. Ok, thanks for the info. The

[sqlalchemy] Extending SQL Alchemy core (0.7.x) with new Select type statement

2013-05-10 Thread Dan Farmer
I'm trying to extend SQLA with a construct for using SQL Server's PIVOT functionality. I've written a class and a @compiles function to generate the query for this and this produces the correct query (e.g., given a sqlalchemy.Table and some Column objects it produces the right query). My