Re: [sqlalchemy] SELECT .. BULK COLLECT INTO ...

2022-10-05 Thread mkmo...@gmail.com
Perfect, thank you Mike. Best regards, Matthew On Wednesday, October 5, 2022 at 11:51:39 AM UTC-7 Mike Bayer wrote: > Select does not have a hook for that particular spot in the SQL > compilation, so unless you rewrote all of visit_select, your best bet is to > stick with simple string

Re: [sqlalchemy] SELECT .. BULK COLLECT INTO ...

2022-10-05 Thread Mike Bayer
Select does not have a hook for that particular spot in the SQL compilation, so unless you rewrote all of visit_select, your best bet is to stick with simple string replacement. this does not in any way preclude you from using the compiler extension, get the text from the compiler then do

[sqlalchemy] SELECT .. BULK COLLECT INTO ...

2022-10-05 Thread mkmo...@gmail.com
Hello, I am generating Oracle PLSQL using sqlalchemy core. I would like to generate the following output: SELECT foo, bar BULK COLLECT INTO l_foos FROM baz; Is there a mechanism to insert a string after the select column list and before the FROM? In sql/compiler.py:visit_select