Lambda expressions are anonymous functions which are passed as arguments to higher-order SQL functions.
->
:
x -> 2 + (SELECT 3)
x -> max(y)
transform
:
numbers | squared_numbers |
---|---|
[1, 2] | [1, 4] |
[3, 4] | [9, 16] |
[5, 6, 7] | [25, 36, 49] |
transform
can be also
employed to safely cast the elements of an array to strings:
price_tags |
---|
[100] |
[30] |
f(x) = ax + b
with transform
:
xvalues | a | b | linear_function_values |
---|---|---|---|
[1, 2] | 10 | 5 | [15, 25] |
[3, 4] | 4 | 2 | [14, 18] |
100
with any_match
{.interpreted-text role=“func”}:
regexp_replace
:
reduce_agg
: