[BUG]: Drizzle Kit CLI commands fail with error "Cannot find module '../../dist/http'"

### Report hasn't been filed before.

- [x] I have verified that the bug I'm about to report hasn't been filed before.

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

0.44.1

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

0.31.1

### Other packages

_No response_

### Describe the Bug

When using drizzle kit commands specifically in the CLI like migrate generate or even studio the following error is reported in my console

Node v22.13.1
PNPM v10.0.0

Working inside of a monorepo (Turborepo) drizzle installed in its own package @repo/database
cannot call drizzle kit commands from within the package

The following error is reported:

```sh
C:\Users\user\dev\tools\packages\database> pnpm dotenv -e ..\..\.env.local -- pnpm drizzle-kit studio
No config path provided, using default 'drizzle.config.ts'
Reading config file 'C:\Users\user\dev\tools\packages\database\drizzle.config.ts'
Cannot find module '../../dist/http'
Require stack:
- C:\Users\user\dev\tools\node_modules\.pnpm\drizzle-kit@0.31.1\node_modules\drizzle-kit\bin.cjs
```