[BUG]: drizzle-kit does not support `node:sqlite`

[hyunbinseo]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

1.0.0-beta.17-67b1795

What version of drizzle-kit are you using?

1.0.0-beta.17-67b1795

Other packages

No response

Describe the Bug

Reproduction hyunbinseo/svelte-kit-template@c2321da

pnpm i && pnpm db:generate && pnpm db:migrate

No config path provided, using default 'drizzle.config.ts'
Reading config file 'D:\svelte-kit-template\drizzle.config.ts'

Please install either 'better-sqlite3', 'bun', '@libsql/client' or '@tursodatabase/database' for Drizzle Kit to connect to SQLite databases
For the 'bun' driver, run your script using: bun --bun

Maybe add a node-sqlite driver option?

type Config = {
  dialect: Verify<Dialect, 'sqlite'>;
  driver: Verify<Driver, 'd1-http'>;
  dbCredentials: {
    accountId: string;
    databaseId: string;
    token: string;
  };
} | {
  dialect: Verify<Dialect, 'sqlite'>;
  driver: Verify<Driver, 'expo'>;
} | {
  dialect: Verify<Dialect, 'sqlite'>;
  driver: Verify<Driver, 'durable-sqlite'>;
} | {
  dialect: Verify<Dialect, 'sqlite'>;
  driver: Verify<Driver, 'sqlite-cloud'>;
}

[AleksandrSherman]

Hello @hyunbinseo

It will be a part of Beta 18 release. I will ping you as it goes live

[AndriiSherman]

should be fixed in drizzle-kit@beta and drizzle-orm@beta which should have a beta.18 alias

[hyunbinseo]

@AndriiSherman Is the better-sqlite3 driver usage intended? Hope there is no incompatibility.

# dependencies:
- drizzle-kit 1.0.0-beta.17-67b1795
+ drizzle-kit 1.0.0-beta.18-7eb39f0
- drizzle-orm 1.0.0-beta.17-67b1795
+ drizzle-orm 1.0.0-beta.18-7eb39f0

drizzle-kit migrate

No config path provided, using default 'drizzle.config.ts'
Reading config file 'D:\svelte-kit-template\drizzle.config.ts'
Using 'better-sqlite3' driver for database querying