Confusion About Using `Effect.promise` with `effect/sql-drizzle`
as a followup to this: effect-beginners-🚀Understanding the use of Effect.promise with Drizzle calls in Effect TS, i'm confused again.
as i understand it, effect/sql-drizzle patches drizzle to return effects. in that case, why is it necessary to use
what am i missing? what should my mental model of using
as i understand it, effect/sql-drizzle patches drizzle to return effects. in that case, why is it necessary to use
Effect.promise when calling $returningId? not wrapping it with Effect.promise causes the call to return an empty array (i.e. not returning the id)what am i missing? what should my mental model of using
Effect.promise with effect/sql-drizzle be?