sandbox.txt

# Examples for converting 

SELECT * FROM CustomerTable
WHERE CustomerTable.cno = 5

HgDB.query(CustomerTable.eq.cno(5))
// should we rename "query" to "select"?

SELECT cname, cno FROM CustomerTable
WHERE CustomerTable.cno = 5

HgDB.query(CustomerTable.eq.cno(5)).






// TODO this syntax (make it efficient too by selecting index)
// OrderTbl.query(OrderTbl.on.ono, 1020);

// static class solution with FieldExtractableValue
HgQuery.query(OrderTbl.eq.ono(5), OrderTbl.eq.cno(null));

HgQuery.query(OrderTbl.lt.ono(5));

HgQuery.query(OrderTbl.predicate.ono(value -> value < 5));

HgQuery.query(OrderTbl.predicate.ono(new HgPredicate<Integer>() {
                        public boolean predicate(Integer value) {
                                return value < 5;
                        }
                }));



// original table solution
OrderTbl.query(OrderTbl.on.ono, 5, OrderTbl.on.cno, null);

OrderTbl.query(OrderTbl.equal.ono(5), OrderTbl.equal.cno(null));

// All FieldExtractable instances for each field in "X"
XTable.field.*

// All FieldExtractableJoinInput instances
XTable.on.*

// All implicit predicates 
XTable.eq.*
XTable.ne.*
XTable.lt.*
XTable.le.*
XTable.gt.*
XTable.ge.*

// All explicit predicates specified by user using HgPredicate
XTable.predicate.*

public interface HgPredicate<T> {
    public boolean predicate(T val);
}










    CustomerTable.on.ono().as(CustomerTable.createAlias());

    CustomerTable.on.ono()

    CustomerTable.as(...).on.ono(); // is this feasible?

    TableID<Person> parent = PersonTable.createAlias();
    CustomerTable.as(parent).on.ono();


    CustomerTable.eq.ono(42); // this is bad
    CustomerTable.ono.eq(42); // reads better, makes more sense