List Files | Just Commands | Repo | Logs

← back | Copy

function escapeSQLString(value: string): string {
  if (value === "") return "''";
  return `'${value.replace(/'/g, "''")}'`;
}

function escapeSQLValue(value: unknown): string {
  if (value === null || value === undefined) {
    return "NULL";
  }

  if (typeof value === "string") {
    return escapeSQLString(value);
  }

  if (typeof value === "number") {
    return value.toString();
  }

  if (value instanceof Date) {
    const formatted = value.toISOString().slice(0, 19).replace("T", " ");
    return `'${formatted}'`;
  }

  throw new Error(`Unsupported SQL type: ${typeof value}`);
}