Column colA = new MutableColumn("colA", null, tableAB, 0, true);
Column colB = new MutableColumn("colB", null, tableAB, 1, true);
Column colC = new MutableColumn("colC", null, tableC, 0, true);
Query q = dc.query().from(tableAB).leftJoin(tableC).on(colB, colC)
.select(colA).as("a").select(colB).as("b").select(colC).as("c")
.toQuery();
assertEquals(
"SELECT tableAB.colA AS a, tableAB.colB AS b, tableC.colC AS c FROM tableAB LEFT JOIN tableC ON tableAB.colB = tableC.colC",