DECLARE d DATE DEFAULT CURRENT_DATE();
CREATE TEMP FUNCTION Add(x INT64, y INT64) AS (x + y);
SELECT Add(3, 4);

I'm having an issue running a chain of statements that depend on each other in a common session. I'm using a single connection and cursor behind the scene.

It appears that the statements are not chained and the session isn't persisted. Any clue on how to solve this?

Other DBAPI implementations allow this type of chaining, and using the same logic with this driver does not work properly.