Migration error with node ESM module

[tatchi]

I get this error in a Node project that compiles to ESM modules

Exited failure state: Error: {"reason":"import-error","message":"Could not import migration \"1_create_people\"\n\nError [ERR_REQUIRE_ESM]: require() of ES Module /Users/corentin/Dev/temp/use-relative-time/dist/src/migrations/0001_create_people.js from /Users/corentin/Dev/temp/use-relative-time/node_modules/.pnpm/@[email protected]_@[email protected][email protected]/node_modules/@sqlfx/sql/Migrator/Node/dist/sqlfx-sql-Migrator-Node.cjs.dev.js not supported.\nInstead change the require of 0001_create_people.js in /Users/corentin/Dev/temp/use-relative-time/node_modules/.pnpm/@[email protected]_@[email protected][email protected]/node_modules/@sqlfx/sql/Migrator/Node/dist/sqlfx-sql-Migrator-Node.cjs.dev.js to a dynamic import() which is available in all CommonJS modules.","_tag":"MigrationError"}

I made a reproduction repo available at https://github.com/tatchi/sqlx-repro

pnpm i
pnpm run build
node dist/src/main.js

It works if we compile to CommonJS. You can test with common branch

git checkout common
pnpm run build
node dist/src/main.js

[tim-smart]

We have updated the effect build processes, which I think will have fixed this.

[tatchi]

Thanks, I confirm it works now 🤗