How to use leap.orm.query

/**
 * Adds a not like operator with the given parameter.
 */
default CriteriaWhere<T> not_like(String pattern) {
  return op(Op.NOT_LIKE.getValue()).param(pattern);
}

/**
 * Adds a condition expression "name = param", such as cnd("id",100);
 */
default CriteriaWhere<T> cnd(String name,Object param) {
  return name(name).op(Op.EQ.getValue()).param(param);
}

@Override
public T single() throws EmptyRecordsException, TooManyRecordsException {
  return limit(2).result().single();
}

@Override
public T firstOrNull() {
  return limit(1).result().firstOrNull();
}

@Override
public T singleOrNull() throws TooManyRecordsException {
  return limit(2).result().singleOrNull();
}

@Override
public T first() throws EmptyRecordsException {
  return limit(1).result().first();
}

@Override
public List<T> list() {
  if(null == result) {
    result = query.result(page);
  }
  return result.list();
}

/**
 * Adds an 'or' condition expression "and name op param", such as and("id",,100);
 */
default CriteriaWhere<T> or(String name,Object param) {
  return or().cnd(name, param);
}

/**
 * Adds an 'and' condition expression "and name op param", such as and("id","=",100);
 */
default CriteriaWhere<T> and(String name,String op,Object param) {
  return and().cnd(name, op, param);
}

/**
 * Adds and operator.
 */
default CriteriaWhere<T> and() {
  return append(" and ");
}

@Override
public CriteriaQuery<T> addSelectItem(String fieldOrExpr) {
  builder.addExtraSelectItem(fieldOrExpr);
  return this;
}

/**
 * Adds a '>=' operator with the given parameter.
 */
default CriteriaWhere<T> ge(Object param) {
  return op(Op.GE.getValue()).param(param);
}

/**
 * Adds a condition expression "name op param", such as cnd("id","=",100);
 */
default CriteriaWhere<T> cnd(String name,Op op,Object param) {
  return name(name).op(op.getValue()).param(param);
}

/**
 * Adds a '>' operator with the given parameter.
 */
default CriteriaWhere<T> gt(Object param) {
  return op(Op.GT.getValue()).param(param);
}

/**
 * Adds a like operator with the given parameter.
 */
default CriteriaWhere<T> like(String pattern) {
  return op(Op.LIKE.getValue()).param(pattern);
}

/**
 * Adds a in operator with the given parameter.
 */
default CriteriaWhere<T> in(Object... array) {
  return op(Op.IN.getValue()).param(array);
}

/**
 * Adds a '=' operator with the given parameter.
 */
default CriteriaWhere<T> eq(Object param) {
  return op(Op.EQ.getValue()).param(param);
}

/**
 * Adds a not in operator with the given parameter.
 */
default CriteriaWhere<T> not_in(Object... array) {
  return op(Op.NOT_IN.getValue()).param(array);
}

/**
 * Adds a '<=' operator with the given parameter.
 */
default CriteriaWhere<T> le(Object param) {
  return op(Op.LE.getValue()).param(param);
}

/**
 * Adds a '<' operator with the given parameter.
 */
default CriteriaWhere<T> lt(Object param) {
  return op(Op.LT.getValue()).param(param);
}