Генератор или агент: что выгоднее генерировать по правилам

import { readFileSync, writeFileSync } from "node:fs";

const SQL = { int: "INTEGER", string: "VARCHAR", text: "TEXT", bool: "BOOLEAN", decimal: "NUMERIC(12, 2)", datetime: "TIMESTAMP" };
const snake = s => s.replace(/[A-Z]/g, c => "_" + c.toLowerCase());

function column(f) {
  let type = SQL[f.type];
  if (f.type === "string") type += `(${f.length ?? 255})`;
  const parts = [snake(f.name), type];
  if (f.primary) parts.push("PRIMARY KEY");
  else if (!f.nullable) parts.push("NOT NULL");
  if (f.unique) parts.push("UNIQUE");
  return "  " + parts.join(" ");
}

const e = JSON.parse(readFileSync("entities/order.json", "utf8"));
const sql = `-- GENERATED from entities/order.json. Do not edit.\nCREATE TABLE ${e.table} (\n${e.fields.map(column).join(",\n")}\n);\n`;
writeFileSync(`migrations/${e.table}.sql`, sql);

import { readFileSync, writeFileSync } from "node:fs";

type FieldType = "int" | "string" | "text" | "bool" | "decimal" | "datetime";
interface Field { name: string; type: FieldType; length?: number; nullable?: boolean; unique?: boolean; primary?: boolean }
interface Entity { name: string; table: string; fields: Field[] }

const SQL: Record<FieldType, string> = { int: "INTEGER", string: "VARCHAR", text: "TEXT", bool: "BOOLEAN", decimal: "NUMERIC(12, 2)", datetime: "TIMESTAMP" };
const snake = (s: string): string => s.replace(/[A-Z]/g, c => "_" + c.toLowerCase());

function column(f: Field): string {
  const type = f.type === "string" ? `VARCHAR(${f.length ?? 255})` : SQL[f.type];
  const parts = [snake(f.name), type];
  if (f.primary) parts.push("PRIMARY KEY");
  else if (!f.nullable) parts.push("NOT NULL");
  if (f.unique) parts.push("UNIQUE");
  return "  " + parts.join(" ");
}

const e: Entity = JSON.parse(readFileSync("entities/order.json", "utf8"));
writeFileSync(`migrations/${e.table}.sql`, `CREATE TABLE ${e.table} (\n${e.fields.map(column).join(",\n")}\n);\n`);

<?php
// bin/generate-sql.php entities/order.json
$sqlTypes = ['int' => 'INTEGER', 'text' => 'TEXT', 'bool' => 'BOOLEAN', 'decimal' => 'NUMERIC(12, 2)', 'datetime' => 'TIMESTAMP'];
$snake = fn (string $s): string => strtolower(preg_replace('/[A-Z]/', '_$0', $s));

$e = json_decode(file_get_contents($argv[1]), true, flags: JSON_THROW_ON_ERROR);
$columns = [];
foreach ($e['fields'] as $f) {
    $type = $f['type'] === 'string' ? sprintf('VARCHAR(%d)', $f['length'] ?? 255) : $sqlTypes[$f['type']];
    $parts = [$snake($f['name']), $type];
    if ($f['primary'] ?? false) {
        $parts[] = 'PRIMARY KEY';
    } elseif (!($f['nullable'] ?? false)) {
        $parts[] = 'NOT NULL';
    }
    if ($f['unique'] ?? false) {
        $parts[] = 'UNIQUE';
    }
    $columns[] = '  ' . implode(' ', $parts);
}
file_put_contents("migrations/{$e['table']}.sql", "CREATE TABLE {$e['table']} (\n" . implode(",\n", $columns) . "\n);\n");

import json
import re
import sys
from pathlib import Path

SQL = {"int": "INTEGER", "text": "TEXT", "bool": "BOOLEAN", "decimal": "NUMERIC(12, 2)", "datetime": "TIMESTAMP"}

def snake(s: str) -> str:
    return re.sub(r"[A-Z]", lambda m: "_" + m.group().lower(), s)

def column(f: dict) -> str:
    t = f"VARCHAR({f.get('length', 255)})" if f["type"] == "string" else SQL[f["type"]]
    parts = [snake(f["name"]), t]
    if f.get("primary"):
        parts.append("PRIMARY KEY")
    elif not f.get("nullable"):
        parts.append("NOT NULL")
    if f.get("unique"):
        parts.append("UNIQUE")
    return "  " + " ".join(parts)

e = json.loads(Path(sys.argv[1]).read_text(encoding="utf-8"))
body = ",\n".join(column(f) for f in e["fields"])
Path(f"migrations/{e['table']}.sql").write_text(f"CREATE TABLE {e['table']} (\n{body}\n);\n", encoding="utf-8")