prqlc 0.13.11

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

# mssql:test
# sqlite:skip (see https://github.com/rusqlite/rusqlite/issues/1211)
from invoices
take 5
select {
    total_original = (total | math.round 2),
    total_x = (math.pi - total | math.round 2 | math.abs),
    total_floor = (math.floor total),
    total_ceil = (math.ceil total),
    total_log10 = (math.log10 total | math.round 3),
    total_log2 = (math.log 2 total | math.round 3),
    total_sqrt = (math.sqrt total | math.round 3),
    total_ln = (math.ln total | math.exp | math.round 2),
    total_cos = (math.cos total | math.acos | math.round 2),
    total_sin = (math.sin total | math.asin | math.round 2),
    total_tan = (math.tan total | math.atan | math.round 2),
    total_deg = (total | math.degrees | math.radians | math.round 2),
    total_square = (total | math.pow 2 | math.round 2),
    total_square_op = ((total ** 2) | math.round 2),
}