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
}