Workaround to broken ?raw imports in vitest-pool-workers 0.12.x

[mjul]

Prior to @cloudflare/vitest-pool-workers v0.12.x we could import files verbatim like this, via a Vite feature:

import dropTables from "../fixtures/drop-all-tables-conditionally.sql?raw";
import migration001 from "../../migrations/0001_foo_schema.sql?raw";
import migration002 from "../../migrations/0002_bar_tables.sql?raw";

The above no longer works.

Here is a workaround:

// Note that it depends on `sqlPlugin` in your vitest  config.ts to handle .sql imports.
const fixtureModules = import.meta.glob("../fixtures/*.sql", {
  import: "default",
  eager: true,
});
const dropTables = fixtureModules[
  "../fixtures/drop-all-tables-conditionally.sql"
] as string;

In order for this to work, add this to the relevant vitest config file (e.g. vitest.integration.config.ts):

// This plugin allows importing .sql files as raw strings,
// something that is no longer supported via ?raw suffix since
// @cloudflare/vitest-pool-workers v0.12.x.
//
// See tests/api/setup.ts for usage
function sqlPlugin() {
  return {
    name: "vite-plugin-sql",
    transform(content: string, id: string) {
      if (id.endsWith(".sql")) {
        return {
          code: `export default ${JSON.stringify(content)};`,
          map: null,
        };
      }
    },
  };
}

export default defineWorkersConfig({
  // Use the plugin in this vitest configuration
  plugins: [sqlPlugin()],
  // ...
});

[edmundhung]

Hi @mjul, i can confirm this is a regression in v0.12.0. The issue is that wrangler 4.57.0 added .sql to the default Text module rules, which conflicts with Vite's ?raw handling.

For now, you can just remove the ?raw suffix since .sql files are now loaded as Text modules by default:

import sql from "./query.sql";

We have a fix up at #12056 that should go out in the next release.

[mjul]

@edmundhung thanks a lot for the quick turn-around on this. I thought at least I would document how to work around it, but I am glad you found the cause so the simpler imports will work again. Good job.