Function exportBaseSQL

src/lib/data/sql-export/export-sql-script.ts:154–721

({
    diagram,
    targetDatabaseType,
    isDBMLFlow = false,
    onlyRelationships = false,
    skipFKGeneration = false,
}: {
    diagram: Diagram;
    targetDatabaseType: DatabaseType;
    isDBMLFlow?: boolean;
    onlyRelationships?: boolean;
    skipFKGeneration?: boolean;
})

};

export const exportBaseSQL = ({
    diagram,
    targetDatabaseType,
    isDBMLFlow = false,
    onlyRelationships = false,
    skipFKGeneration = false,
}: {
    diagram: Diagram;
    targetDatabaseType: DatabaseType;
    isDBMLFlow?: boolean;
    onlyRelationships?: boolean;
    skipFKGeneration?: boolean;
}): string => {
    const { tables, relationships } = diagram;

    if (!tables || tables.length === 0) {
        return '';
    }

    if (!isDBMLFlow && diagram.databaseType === targetDatabaseType) {
        switch (diagram.databaseType) {
            case DatabaseType.SQL_SERVER:
                return exportMSSQL({ diagram, onlyRelationships });
            case DatabaseType.POSTGRESQL:
                return exportPostgreSQL({ diagram, onlyRelationships });
            case DatabaseType.SQLITE:
                return exportSQLite({ diagram, onlyRelationships });
            case DatabaseType.MYSQL:
            case DatabaseType.MARIADB:
                return exportMySQL({ diagram, onlyRelationships });
            default:
                return exportPostgreSQL({ diagram, onlyRelationships });
        }
    }

    // Deterministic cross-dialect exports (PostgreSQL to MySQL/SQL Server)
    // These do not use LLM and provide consistent, predictable output
    if (!isDBMLFlow && diagram.databaseType === DatabaseType.POSTGRESQL) {
        if (
            targetDatabaseType === DatabaseType.MYSQL ||
            targetDatabaseType === DatabaseType.MARIADB
        ) {
            return exportPostgreSQLToMySQL({ diagram, onlyRelationships });
        }
        if (targetDatabaseType === DatabaseType.SQL_SERVER) {
            return exportPostgreSQLToMSSQL({ diagram, onlyRelationships });
        }
    }

    // Filter out the tables that are views
    const nonViewTables = tables.filter((table) => !table.isView);

    // Align the data types based on foreign key relationships
    alignForeignKeyDataTypes(diagram);

    // Initialize the SQL script string
    let sqlScript = '';