SQL
Lambda Functions
Lambda functions enable the use of more complex and flexible expressions in queries.
DuckDB supports several scalar functions that operate on [`LIST`s](#docs:sql:data_types:list) and
accept lambda functions as parameters
in the form `(parameter1, parameter2, ...) -> expression`.
If the lambda function has only one parameter, then the parentheses can be omitted.
The parameters can have any names.
For example, the following are all valid lambda functions:  
* `param -> param > 1`
* `s -> contains(concat(s, 'DB'), 'duck')`
* `(x, y) -> x + y`