public With translate(List<WithQueryCommand> with) {
if (with == null || with.isEmpty()) {
return null;
}
With result = new With();
ArrayList<WithItem> items = new ArrayList<WithItem>(with.size());
for (WithQueryCommand withQueryCommand : with) {
WithItem item = new WithItem();
item.setTable(translate(withQueryCommand.getGroupSymbol()));
if (withQueryCommand.getColumns() != null) {
List<ColumnReference> translatedElements = new ArrayList<ColumnReference>(withQueryCommand.getColumns().size());
for (ElementSymbol es: withQueryCommand.getColumns()) {
translatedElements.add(translate(es));
}
}
item.setSubquery(translate(withQueryCommand.getCommand()));
}
result.setItems(items);
return result;
}