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
from [{track_id=0, album_id=1, genre_id=2}]
select { AA=track_id, album_id, genre_id }
sort AA
join side:left [{album_id=1, album_title="Songs"}] (==album_id)
select { AA, AT = album_title ?? "unknown", genre_id }
filter AA < 25
join side:left [{genre_id=1, genre_title="Rock"}] (==genre_id)
select { AA, AT, GT = genre_title ?? "unknown" }