sqlalchemy supports INSERT INTO ... (SELECT .. ) ?

[Kent]

Couldn't find answer in docs, does sqlalchemy support:

INSERT INTO ... (SELECT .. )

instead of

INSERT INTO ... VALUES...

[Michael Bayer]

its not built in at the moment but there is a recipe in the docs for @compiles

http://docs.sqlalchemy.org/en/latest/core/compiler.html#compiling-sub-elements-of-a-custom-expression-construct

kind of amazing nobody's yet contributed a patch for this, I show people that recipe for a few years now :)

--
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/IIxzN-i9740J.
To post to this group, send email to sqlal...@googlegroups.com.
To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.

[Kent Bower]

Thanks for pointing me there.  As an aside, the recipe would be more bulletproof if it specified the columns (order).  Currently, it assumes sqlalchemy knows the order of the columns in the database, which it may not.

Thanks again!

[Michael Bayer]

so many great ideas for the eventual contributor ! ;)

ideally it would be a method on insert() itself, table.insert().from(select([...])..., cols=('x', 'y', 'z')) or something like that.   Maybe people have suggestions.

[Kent Bower]

Yeah, I knew it was a hint... ;)   So many great ideas, so little time. :(