Function getQuotedTableName

src/lib/data/sql-export/export-sql-script.ts:100–129

(
    table: DBTable,
    isDBMLFlow: boolean = false
)

// Helper function to properly quote table/schema names with special characters
const getQuotedTableName = (
    table: DBTable,
    isDBMLFlow: boolean = false
): string => {
    // Check if a name is already quoted
    const isAlreadyQuoted = (name: string) => {
        return (
            (name.startsWith('"') && name.endsWith('"')) ||
            (name.startsWith('`') && name.endsWith('`')) ||
            (name.startsWith('[') && name.endsWith(']'))
        );
    };

    // Only add quotes if needed and not already quoted
    const quoteIfNeeded = (name: string) => {
        if (isAlreadyQuoted(name)) {
            return name;
        }
        const needsQuoting = /[^a-zA-Z0-9_]/.test(name) || isDBMLFlow;
        return needsQuoting ? `"${name}"` : name;
    };

    if (table.schema) {
        const quotedSchema = quoteIfNeeded(table.schema);
        const quotedTable = quoteIfNeeded(table.name);
        return `${quotedSchema}.${quotedTable}`;
    } else {
        return quoteIfNeeded(table.name);
    }
};

const getQuotedFieldName = (
    fieldName: string,