Disabling prepared statements entirely with SQLAlchemy?

I have some SQL strings with multiple commands (i.e. INSERT a; INSERT B;), which cannot be made into prepared statements.

When using SQLAlchemy, it seems like asyncpg is always called in such a way that prepared statements are always generated.

There is an issue on a related subject, where the prepared_statement_cache_size option can be used to avoid cacheing the statements. But this setting does not stop them from being used entirely. Most of the above issue is only about changing the way such statements are named/identified/stored. Even with this set to 0, the statements are still created and called.

The only way I can find to get around this problem is to call asyncpg more directly:

engine = create_async_engine()
async with engine.begin() as conn:
    raw = await conn.get_raw_connection()
    await raw.cursor()._connection.execute(script)

Is there any nicer solution for this? I'd like to skip get_raw_connection, .cursor() and _connection, and use SQLAlchemy more as intended, but without generating any prepared statements.

Also, a somewhat related question, does SQLAlchemy provide a way of accessing asyncpg's copy_to_table other than the above? I can't find much documentation about this, nor anything specific to COPY in the source.

MagicStack / asyncpg

Disabling prepared statements entirely with SQLAlchemy? #1041