Feature Request: Support for Connecting to Local SQLite Databases with D1 Driver in Drizzle Studio

[sugar-cat7]

I am currently working with Drizzle Studio and facing a limitation regarding the connection to local SQLite databases while using the D1 driver.
When applying migrations with wrangler d1 migrations apply local-db --local, an SQLite file is generated under .wrangler/state/v3/d1/miniflare-D1DatabaseObject.
However, there is no direct way to connect to this SQLite file using the D1 driver in the Drizzle Studio configuration.

The existing drizzle.config.ts settings for the D1 driver only allow for wranglerConfigPath and dbName, which does not support specifying a local SQLite file path. As a workaround, I am currently using the better-sqlite driver for local development by specifying the path under .wrangler in dbCredentials.

Here is drizzle.config.ts for reference:

import type { Config } from "drizzle-kit";

const cfConfig = {
  schema: "./schema/db/index.ts",
  driver: "d1",
  dbCredentials: {
    wranglerConfigPath: "./wrangler.toml",
    dbName: "test",
  },
  verbose: false,
  strict: true,
} satisfies Config;

const localConfig = {
  schema: "./schema/db/index.ts",
  driver: "better-sqlite",
  dbCredentials: {
    url: process.env.DB_URL!,
  },
} satisfies Config;

export default process.env.NODE_ENV === "production" ? cfConfig : localConfig;

I would like to request a feature or enhancement that allows direct connection to the local SQLite file generated by wrangler d1 migrations apply local-db --local using the D1 driver. This feature would greatly simplify the development process and provide a more integrated experience with Drizzle Studio.

[ProximaB]

Discussion about this issue could be found also here: drizzle-team/drizzle-orm#1545