I’m going to do what’s called a Pro Gamer Move™ and strategically redirect you to @arybczak for the finer details of unlifting.
I wrote personal bindings to pg-transact, whose implementation you can see here: pg-transact-effectful/src/Effectful/PostgreSQL/Transact/Effect.hs at main · Kleidukos/pg-transact-effectful · GitHub (TW: it’s rife with unsafeEff_).