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

# mssql:test
from tracks
derive d = album_id + 1
group d (
    aggregate {
        n1 = (track_id | sum),
    }
)
sort d
take 10
select { d1 = d, n1 }