[BUG]: Cannot find module error when import includes '.js' file extension in TypeScript project

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

0.32.1

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

0.23.0

### Describe the Bug

Attempting to generate a migration script fails with 'cannot find module' when a module path includes the '.js' file extension in TypeScript project. Similar issue, if not the same, https://github.com/drizzle-team/drizzle-orm/issues/849

Sample project to recreate the issue
https://github.com/Skulltulla/drizzle-kit-mirror-fork/tree/issues/drizzle-issues-0000

### Expected behavior

Generating a migration completes successfully when the module import path includes a '.js' file extension.

### Environment & setup

5.15.153.1-microsoft-standard-WSL2 #1 SMP Fri Mar 29 23:14:13 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux