SQL-like syntax (Under development. Do not use at production yet!)

select [cols] from t [where filters] [by groups]

o)\l "sql";
o)t:(+:)`a`b`c`d!(!10;!10;!10;!10);
o)select [8] M:min a,max b,last d from t where c<100,c>1 by c
c M f1 f2
---------
2 2 2  2
3 3 3  3
4 4 4  4
5 5 5  5
6 6 6  6
7 7 7  7
8 8 8  8
9 9 9  9
o)