private String getInsertSql(String tableName, List<Header> headerList, List<String> row, MetaData metaSchema) {
        if (CollectionUtils.isEmpty(row) || ObjectUtils.allNull(row.toArray())) {
            return "";
        }
        StringBuilder script = new StringBuilder();
        script.append("INSERT INTO ").append(tableName)
                .append(" (");

        ValueProcessor valueProcessor = metaSchema.getValueProcessor();
        for (int i = 1; i < row.size(); i++) {
            Header header = headerList.get(i);
            //String newValue = row.get(i);
            //if (newValue != null) {
            script.append(metaSchema.getMetaDataName(header.getName()))
                    .append(",");
            // }
        }
        script.deleteCharAt(script.length() - 1);
        script.append(") VALUES (");
        for (int i = 1; i < row.size(); i++) {
            String newValue = row.get(i);
            //if (newValue != null) {
            Header header = headerList.get(i);
            SQLDataValue sqlDataValue = new SQLDataValue();
            DataType dataType = new DataType();
            dataType.setDataTypeName(header.getDataType());
            dataType.setScale(header.getDecimalDigits());
            dataType.setPrecision(header.getColumnSize());
            sqlDataValue.setValue(newValue);
            sqlDataValue.setDataType(dataType);
            String value =  valueProcessor.getSqlValueString(sqlDataValue);
            script.append(value)
                    .append(",");
            //}
        }
        script.deleteCharAt(script.length() - 1);
        script.append(")");
        return script.toString();

    }
Generates a multi-row INSERT SQL statement.

@param schemaName Name of the database schema.
@param tableName  Name of the table to insert into.
@param columnList Optional list of column names.
@param valueLists List of lists, each inner list represents values for a row.
@return The complete multi-row INSERT SQL statement.
chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/jdbc/DefaultSqlBuilder.java