On May 14, 2014, at 6:35 PM, Hunter Blanks <[email protected]> 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
