in src/main/java/com/epam/digital/data/platform/liquibase/extension/sqlgenerator/core/DdmCreateMany2ManyGenerator.java [55:79]
private StringBuilder getMainSql(DdmCreateMany2ManyStatement statement) {
StringBuilder buffer = new StringBuilder();
buffer.append("SELECT ");
buffer.append(statement.getMainTableName())
.append(".")
.append(statement.getMainTableKeyField());
buffer.append(", UNNEST(")
.append(statement.getMainTableName())
.append(".")
.append(statement.getReferenceKeysArray())
.append(")");
buffer.append(" AS ");
buffer.append(statement.getReferenceColumnName());
if (!statement.getMainTableColumns().isEmpty()) {
buffer.append(", ");
buffer.append(getListOfColumns(statement.getMainTableName(), statement.getMainTableColumns()));
}
buffer.append(" FROM ");
buffer.append(statement.getMainTableName());
return buffer;
}