1.eq:等于=
例:eq("name", "老王")
--->name = '老王'
2.ne:不等于<>
例: ne("name", "老王")
--->name <> '老王'
3.gt:大于>
例: gt("age", 18)
--->age > 18
4.lt小于<
例: lt("age", 18)
--->age < 18
5.le:小于等于<=
例: le("age", 18)
--->age <= 18
6.between
BETWEEN 值1 AND 值2
例: between("age", 18, 30)
--->age between 18 and 3
7.like
%值%
例: like("name", "王")
--->name like '%王%'
8.likeleft %值
例: likeLeft("name", "王")
--->name like '%王'
9.isnull
例: isNull("name")
--->name is null
10.in
例: in("age",{1,2,3})
--->age in (1,2,3)
11.insql
例: inSql("id", "select id from table where id < 3")
--->id in (select id from table where id < 3)
12.groupBy
例: groupBy("id", "name")
--->group by id,name
13.orderBy
例: orderBy(true, true, "id", "name")
--->order by id ASC,name ASC
14.having
例: having("sum(age) > {0}", 11)
--->having sum(age) > 11