prql-compiler 0.7.1

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
21
22
23
24
25
26
27

func min <scalar or column> column ->  s"MIN({column})"
func max <scalar or column> column ->  s"MAX({column})"
func sum <scalar or column> column ->  s"SUM({column})"
func avg <scalar or column> column ->  s"AVG({column})"
func stddev <scalar or column> column ->  s"STDDEV({column})"
func average <scalar or column> column ->  s"AVG({column})"
func count <scalar or column> non_null:s"*" ->  s"COUNT({non_null})"
# TODO: Possibly make this into `count distinct:true` (or like `distinct:` as an
# abbreviation of that?)
func count_distinct <scalar or column> column ->  s"COUNT(DISTINCT {column})"

# Window functions
func lag<column> offset column ->  s"LAG({column}, {offset})"
func lead<column> offset column ->  s"LEAD({column}, {offset})"
func first<column> offset column ->  s"FIRST_VALUE({column}, {offset})"
func last<column> offset column ->  s"LAST_VALUE({column}, {offset})"
func rank<column> ->  s"RANK()"
func rank_dense<column> ->  s"DENSE_RANK()"
func row_number<column> ->  s"ROW_NUMBER()"

# Other functions
func round<scalar> n_digits column ->  s"ROUND({column}, {n_digits})"
func as<scalar> `noresolve.type` column ->  s"CAST({column} AS {type})"

# String functions
func lower <text> column -> s"LOWER({column})"
func upper <text> column -> s"UPPER({column})"