[BUG]: transaction hangs forever when using drizzle object inside it

### What version of `drizzle-orm` are you using?

0.28.6

### What version of `drizzle-kit` are you using?

0.19.13

### Describe the Bug

I don't know if this should be considered as a bug or not.

My coworker mistakenly used `db` object instead of transaction `tx`. The code executed but hangs forever.
```
await db.transaction(async (tx) => {
// process is hanging here
await db.select().from(categories);
});
```

### Expected behavior

While this should not be the case and he should use `tx` instead. he should at least get an error if possible.

### Environment & setup

Operating system: osx
package manager: pnpm
postgres version: 14.10

-- libraries
pg: 8.11.3
tsx: 3.13.0
typescript: 5.1.6