Uno schrieb:
the ultimate++ solution just works for very very simple statements
it works for every query. You can write for example:
Select(PRODUCTS[ID], CUSTOMER[NAME])
.From(PRODUCTS)
.InnerJoin(CUSTOMERS)
.On(CUSTOMERS[PRODUCT_ID] == PRODUCTS[ID] && Like(PRODUCTS[NAME], "BOOK%"))
.Where(PRODUCTS[ID] > 10);
You can have another statement in where or even in select..
and "from select"
btw: i don't want to say: "its not possible" - i want
to say: "it is even clear to handle in D" without going the
no-other-way-in-c++ solution