Re: [sqlalchemy] Oracle insert().select_from() with cte

2018-06-12 Thread Mike Bayer
On Tue, Jun 12, 2018 at 6:25 PM, jamesmf wrote: > Hi all, > > Has anyone found a solution to this issue when using CTEs inside an insert > statement in Oracle? > > https://stackoverflow.com/questions/45899044/sqlalchemy-with-clause-cte-with-insert-is-not-compiling-correctly-for-oracle > > The CTEs

[sqlalchemy] Oracle insert().select_from() with cte

2018-06-12 Thread jamesmf
Hi all, Has anyone found a solution to this issue when using CTEs inside an insert statement in Oracle? https://stackoverflow.com/questions/45899044/sqlalchemy-with-clause-cte-with-insert-is-not-compiling-correctly-for-oracle The CTEs show up above the insert statement rather than following it.