前端数据查询抽象

Join Union UnionAll

delete /res/:name Join(TB1(a=1||b=2&&v>=2) as a,Tb2(v=2) as b,a.a=b.b)
delete /res/:name TB1(a=1||b=2&&v>=2||v in [])

update /res/:name data Join(TB1(a=1||b=2&&v>=2) as a,Tb2(v=2) as b,a.a=b.b)

get /res/:name TB1(a=1||b=2&&v>=2||v nin [1,2,3,4])
get /res/:name Join(TB1(a=1||b=2&&v>=2) as a,Tb2(v=2) as b,a.a=b.b)
| group_by() 
| sort(~a,~b) 
| fields(a,b,c,d)
get /res/:name UnionAll(TB1(a=1||b=2&&v>=2) as a,Tb2(v=2) as b,a.a=b.b) | group_by(c1,c2,c3)
| sort(~a,~b)
| fields(count(a) as a1,b,c,d)