`sqlite-node` Transactions Use Effect Semaphores, Not SQL Transactions
Do I understand this correctly that
https://github.com/Effect-TS/effect/blob/main/packages/sql-sqlite-node/src/SqliteClient.ts#L220C5-L232C1
sqlite-node transactions are implemented using Effect semaphores and not SQL transactions?https://github.com/Effect-TS/effect/blob/main/packages/sql-sqlite-node/src/SqliteClient.ts#L220C5-L232C1
