
🔍
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)