Any way to execute commands prior to query?

[mcrumiller]

I need to be able to execute a command prior to sql query, as in the following:

set optimizer = 'on';
SELECT * FROM my_table;

Since connectorx creates and destroys a new connection upon each query, is there any way to supply a set of execute instructions prior to the query that are session-specific?

[surister]

There is currently no:

• setup query as in a query that gets run before connectorx's
• teardown query as in a query that gets run after connectorx's

You can manually pass the queries to read_sql but you'd have to take care of the partitions yourself

[WilliamStam]

im also looking for a solution to this. need to be able to ALTER SESSION SET CURRENT_SCHEMA = XYZ before the queries. changing the username to the schema isnt possible :(