Support for top-level await in ESModule

[DominicRoyStang]

When the kysely.config.ts file contains top-level await or imports a file that has top-level await, and the package.json type field is set to module, running kysely migrate:make <migration name> errors-out with the following message

SyntaxError: await is only valid in async functions and the top level bodies of modules

In my case, this top-level await is used to fetch the database password from a secret manager.

Repro repository: https://github.com/DominicRoyStang/kysely-ctl-async-bug

[igalklebanov]

Hey 👋

Thanks for raising this and providing a reproduction.

[Zn4rK]

It looks like this would be solved with a new version of c12:
https://github.com/unjs/c12/blob/7c425ef16a3f87f468235beddbd0223b2080eba5/package.json#L44

unjs/jiti#72 (comment)

Specifying a newer version of c12 in package.json confirms this:

"resolutions": {
    "c12": "^2.0.1"
  },

[igalklebanov]

Try this preview build:

npm i https://pkg.pr.new/kysely-org/kysely-ctl@07e409c

[noudadrichem]

Same. The new build works for me!

[igalklebanov]

Should be resolved in https://github.com/kysely-org/kysely-ctl/releases/tag/v0.10.0.