Add ability to use any kysely dialect

[ai]

Kysely has a lot of third-party dialects like pglite (useful as in-memory DB for tests or to now run separated DB service during the development).

It would be nice, if we will have JS API to pass dialect as option:

const { dialect } = await KyselyPGlite.create()
await codegen({ dialect })

Upvote & Fund

• We're using Polar.sh so you can upvote and help fund this issue.
• We receive the funding once the issue is completed & confirmed by you.
• Thank you in advance for helping prioritize & fund our backlog.

[maheshbansod]

i had the same issue - i forked this and published a version on JSR: https://jsr.io/@maheshbansod/kysely-codegen

not sure if it will work for every case (or your specific case) though - i haven't tested much, just created this to handle postgres issues on Deno