.addSelectColumn(new ColumnImpl("table2.column2a"))
.where(new ColumnImpl("table2.column2b"), "x");
Criteria criteria = new Criteria();
criteria.addSelectColumn(new ColumnImpl("alias.column1"));
criteria.addAlias("alias", subquery);
criteria.addJoin(
new ColumnImpl("alias.column1"),
new ColumnImpl("table2.column2"));
Query query = SqlBuilder.buildQuery(criteria);