How would I wrap such a transaction with effect-ts? I found suggestions for transactions here in the forum with acquireRelease, but I couldn't find a way to make this work with this API, since acquiring the transaction is starting the function but not resolving it yet. I pass my database connection that is required to start this function as a service. Ideally, I would then have each separate database query wrapped in a effect that receives the transaction instead of a regular database connection.
Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno - GitHub - porsager/postgres: Postgres.js - The Fastest full featured PostgreSQL client for Node.js and Deno