[BUG]:drizzle-kit schema ERR_MODULE_NOT_FOUND

### 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.0

### Other packages

_No response_

### Describe the Bug

When multiple schema (with cross references) are used from different package, you get an ERR_MODULE_NOT_FOUND error.

```
Error [ERR_MODULE_NOT_FOUND]: Cannot find module '[..]\node_modules\@[...]\src\db\schema\models' imported from [..]\node_modules\[..]\src\db\schema\images.ts
at finalizeResolution (node:internal/modules/esm/resolve:283:11)
at moduleResolve (node:internal/modules/esm/resolve:952:10)
at defaultResolve (node:internal/modules/esm/resolve:1188:11)
at ModuleLoader.defaultResolve (node:internal/modules/esm/loader:642:12)
at #cachedDefaultResolve (node:internal/modules/esm/loader:591:25)
at ModuleLoader.getModuleJobForRequire (node:internal/modules/esm/loader:347:53)
at new ModuleJobSync (node:internal/modules/esm/module_job:333:34)
at ModuleLoader.importSyncForRequire (node:internal/modules/esm/loader:320:11)
at loadESMFromCJS (node:internal/modules/cjs/loader:1371:24)
at Module._compile (node:internal/modules/cjs/loader:1511:5) {
code: 'ERR_MODULE_NOT_FOUND',
url: 'file:///[..]/node_modules/[..]/src/db/schema/models'
}
```

with this config:
```
export default defineConfig( {
out: './src/lib/db/migrations',
schema: './node_modules/[...]/src/db/schema',
dialect: 'sqlite',
dbCredentials: {
url: process.env.DATABASE_URL
}
} );
```

If i copy all these schema files into a local directory (like `./src/lib/db/schema`), it works just fine.