Option for type-only generation

[talwat]

Hello!

I wanted to ask whether it would be possible to just generate the types for DB models, and exclude the queries. I'm using sqlc on the backend, and having it generate the corresponding frontend types would be really useful.

If this already exists, I couldn't find the option. Thank you again for making sqlc!

[talwat]

I've used AI to make a temporary script which resolves my issue, but having these as actual options would be nice.

import fs from "fs";
import path from "path";

const ROOT_DIR = path.resolve("app/utils/db");
const INTERFACE_REGEX = /export\s+interface\s+\w+\s*\{[\s\S]*?\}/g;

function processFile(filePath) {
  const source = fs.readFileSync(filePath, "utf8");
  const matches = source.match(INTERFACE_REGEX);

  const output = matches && matches.length ? matches.join("\n\n") + "\n" : "";

  fs.writeFileSync(filePath, output, "utf8");

  const dir = path.dirname(filePath);
  const base = path.basename(filePath);

  if (/_sql\.ts$/.test(base)) {
    const newName = base.replace(/_sql\.ts$/, ".d.ts");
    const newPath = path.join(dir, newName);

    if (newPath !== filePath) {
      fs.renameSync(filePath, newPath);
    }
  }
}

function walk(dir) {
  for (const entry of fs.readdirSync(dir, { withFileTypes: true })) {
    const fullPath = path.join(dir, entry.name);

    if (entry.isDirectory()) {
      walk(fullPath);
    } else if (entry.isFile() && entry.name.endsWith(".ts")) {
      processFile(fullPath);
    }
  }
}

walk(ROOT_DIR);