Refering to this thread and this other thread, FME is doing a lot of things on our sql statement without asking us...
As a PostgreSQL database ingineer, my SQL scripts can be really complex and I want FME to send it to the database wihtout encapsulated it into some darkmagic procedure...
It could be great to have an option to tell FME to send the statement to the database as it is. The dev have to check for the commit part and all of course.
I found another situation.
I want to use FME to perfom a VACUUM FULL after a set of operations.
But I can’t with FME because there is no transformer that allows me to send SQL command without being in a transaction block.
It could be great to have an advanced option in the SQLExecutor to avoid packaging our SQL into a transaction block an to sending it just as it is.
It could allow us to perform VACUUM.