How do I set session configuration parameters using Drizzle and Supabase?

[lsli8888]

Specifically, I want to set pgvector HNSW index configuration parameters for my queries. The parameters are ideally set for the entire session. Unfortunately, my current approach is to invoke three raw queries to set the configuration parameters each and every time before my query:

await db.execute(sql`SET hnsw.iterative_scan = strict_order;`);
await db.execute(sql`SET hnsw.max_scan_tuples = 10000;`);
await db.execute(sql`SET hnsw.ef_search = 80;`);
...
<Then invoke query involving similarity search using pgvector>

This doesn't seem efficient as these three individual statements require three distinct calls, each taking a bit of time.

Unfortunately, Supabase doesn't allow setting these configuration parameters globally like so:

ALTER ROLE <my_role> SET hnsw.iterative_scan = 'strict_order';
ALTER ROLE <my_role> SET hnsw.max_scan_tuples = 10000;
ALTER ROLE <my_role> SET hnsw.ef_search = 80;

As I get 42501 permission errors like so:

ERROR: 42501: permission denied to set parameter "hnsw.max_scan_tuples"

Can Drizzle ORM help me do this in a more efficient way? Can I at least set these configuration parameters once for the entire database session? FYI - I'm just using a single role to perform the similarity search query, so that's why I was attempting the above ALTER ROLE commands. Also, I don't need to wrap the configuration properties setting in a db transaction.