On May 14, 2014, at 6:35 PM, Hunter Blanks <hun...@napofearth.com> wrote:

> Hi,
> 
> Although SQLAlchemy supports PostgreSQL's common table expressions (i.e. WITH 
> statements*)  for SELECT, it does not yet seem to support them for INSERT, 
> UPDATE, or DELETE.
> 
> (1) Can anyone confirm that this is the case? Lest it help, I've attached 
> test cases for UPDATE and DELETE below.
> 
> (2) If this is the case, can anyone offer a guess for what it would involve 
> for me to add these features?

this is the case:

https://bitbucket.org/zzzeek/sqlalchemy/issue/2551/apparently-inserts-and-update-delete-can

it's doable, but not a particularly trivial add and the demand for this feature 
so far has been low.    if you wanted to take a crack at it, it involves 
expanding the current SELECT part of the system appropriately and adding lots 
of tests to the test_cte suite.


-- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to