bug.sql

create table first (id integer primary key);
create table second (id integer primary key);

repro.ts

import connect, { sql } from "@databases/sqlite";

async function main() {
  const db = await connect();
  await db.query(sql.file(__dirname + "/bug.sql"));
  // Following line throws error: "SQLITE_ERROR: no such table: second"
  await db.query(sql`select * from second`);
}

main().catch((e) => {
  console.error(e);
  process.exit(1);
});