SELECT * FROM tab1 #### $tab1 #### SELECT * FROM tab1 WHERE col1 = 'hello' AND col2 = 5 OR col1 = 'world' AND col2 = 7 #### $tab1 matching Relation:{ col1 => 'hello', col2 => 5, col1 => 'world', col2 => 7 } #### SELECT col1, col2, col3, col5, col6, col7, col8 FROM tab #### $tab@{!bigcol4} #### SELECT age, ctry, COUNT(*) AS count_per_age_ctry FROM people GROUP BY age, ctry #### $people@{#@count_per_age_ctry <- !age,ctry} #### $x := $y $y := $x #### recipe count_heads (&$count : NNInt, $search : Text, $people ::= $fed.data.db1.people) { with value-filter filt (Bool <-- $topic : Tuple, $search : Text) { $.name like ('%' ~ $search ~ '%') } $count := r# ($people where ( $>search )) } #### updater make_coprime (&$a : NNInt, &$b : NNInt) { with function gcd (NNInt <-- $a : NNInt, $b : NNInt) { $b = 0 ?? $a !! rtn( a => $b, b => $a mod $b round Down ) } $gcd ::= nlx.lib.gcd( $>a, $>b ) $a := $a div $gcd round Down $b := $b div $gcd round Down }