How might one extend a Delete clause such that I can use USING in the statement?
Something like this (given t2 is a Table (or selectable?)):
Turn this (assuming SomeObject is tied to t1):
q = sess.query(SomeObject)
q = q.filter(...)
q = q.filter(SomeObject.some_column==t2.c.some_other_column)
q.delete().with_hint('USING', [t2]))
DELETE
FROM t1
USING t2
WHERE t1.some_column == t2.some_other_column
;
What if there are multiple Tables (or selectables) in to render?
--
Jon
Software Blacksmith
--
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/groups/opt_out.
