Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1009 B
Raw Blame
import type { FormatOptionsWithLanguage } from "sql-formatter";
import type { SQLDialect } from "@/types";

type FormatResult = {
  data: string;
  error: Error | null;
};

type FormatterLanguage = FormatOptionsWithLanguage["language"];

const convertDialectToFormatterLanguage = (
  dialect: SQLDialect | undefined
): FormatterLanguage => {
  if (dialect === "MYSQL" || dialect === "TIDB" || dialect === "OCEANBASE") {
    return "mysql";
  }
  if (dialect === "POSTGRES") {
    return "postgresql";
  }
  if (dialect === "SNOWFLAKE") {
    return "snowflake";
  }
  return "sql";
};

export const formatSQL = async (
  sql: string,
  dialect: SQLDialect | undefined
): Promise<FormatResult> => {
  const { format } = await import("sql-formatter");
  const options: Partial<FormatOptionsWithLanguage> = {
    language: convertDialectToFormatterLanguage(dialect),
  };

  try {
    return { data: format(sql, options), error: null };
  } catch (error) {
    return { data: "", error: error as Error };
  }
};