->
:
Limitations
Most SQL expressions can be used in a lambda body, with a few exceptions:- Subqueries are not supported:
x -> 2 + (SELECT 3)
- Aggregations are not supported:
x -> max(y)
Examples
Obtain the squared elements of an array column with transform():f(x) = ax + b
with transform():
100
with any_match():