A partial Drizzle adapter

[AlexErrant]

I started to write a Drizzle adapter but eventually realized that (for me) it offered no benefits over Kysely, so I went back to using the excellent https://github.com/Azarattum/CRStore (in particular, https://github.com/Azarattum/CRStore/blob/main/src/lib/database/dialect.ts) There's also https://github.com/subframe7536/kysely-sqlite-tools, which I haven't looked closely at yet.

Here's as far as I got before stopping, in case it helps anyone who prefers Drizzle > Kysely:

import sqliteWasm, { type DB as crDB } from "@vlcn.io/crsqlite-wasm"
import crsqliteUrl from "@vlcn.io/crsqlite-wasm/crsqlite.wasm?url" // https://vitejs.dev/guide/assets.html#explicit-url-imports
import { drizzle } from "drizzle-orm/sqlite-proxy"

async function getDb() {
  const sqlite = await sqliteWasm(() => crsqliteUrl)
  const db = await sqlite.open("whatever.db")
  return db
}

export const ddb = drizzle(async (sql, params, method) => {
  const db = await getDb()
  const stmt = await db.prepare(sql)
  stmt.bind(params)
  try {
    if (method === "run") {
      await stmt.run(null)
      return {
        rows: [],
      }
    } else if (method === "all" || method === "values") {
      const r = await stmt.all(null)
      return {
        rows: r.map(Object.values),
      }
    } else if (method === "get") {
      return {
        // eslint-disable-next-line @typescript-eslint/no-unsafe-argument
        rows: Object.values(await stmt.get(null)),
      }
    } else {
      console.error("Unknown method:", method)
      return { rows: [] }
    }
  } catch (e) {
    console.error(e)
    return { rows: [] }
  } finally {
    await stmt.finalize(null)
  }
})

// ref: https://github.com/drizzle-team/drizzle-orm/tree/main/examples/sqlite-proxy
// I found no relevant Google hits for SQLite's `run`, `all`, `values`, and `get` methods. Please LMK if you know wtf these mean or do.

(If you do prefer Drizzle > Kysely, please let me know why! IMO Kysely has better syntax and more features, especially with ParseJSONResultsPlugin and its ability to return nested objects/arrays).