unable to query the database with the SQLite libsql adapter

import { PrismaClient } from "@prisma/client";

const globalForPrisma = globalThis as unknown as {
  db?: PrismaClient;
};

const DEV_ENV = process.env.NODE_ENV === "development";

export const db =
  globalForPrisma.db ??
  new PrismaClient({
     log: DEV_ENV ? ["query", "error", "warn"] : ["error"]
  });

if (DEV_ENV) globalForPrisma.db = db;

import { createClient, type Client } from "@libsql/client";
import { PrismaLibSQL } from "@prisma/adapter-libsql";
import { PrismaClient } from "@prisma/client";

const globalForPrisma = globalThis as unknown as {
  client?: Client;
};

const DEV_ENV = process.env.NODE_ENV === "development";

const client =
  globalForPrisma.client ??
  createClient({
    url: process.env.DATABASE_URL,
    authToken: process.env.DATABASE_AUTH_TOKEN,
  });

if (DEV_ENV) globalForPrisma.client = client;

const adapter = new PrismaLibSQL(client);

export const db = new PrismaClient({ adapter, log: DEV_ENV ? ["query", "error", "warn"] : ["error"] });