SQL
Transform
**Signature:** `list_transform(list, lambda)`  
**Description:** `list_transform` returns a list that is the result of applying the lambda function to each element of the input list.  
**Aliases:**  
* `array_transform`
* `apply`
* `list_apply`
* `array_apply`  
**Number of parameters excluding indexes:** 1  
**Return type:** Defined by the return type of the lambda function  
#### Examples {#docs:sql:functions:lambda::examples}  
Incrementing each list element by one:  
```sql
SELECT list_transform([1, 2, NULL, 3], x -> x + 1);
```  
```text
[2, 3, NULL, 4]
```  
Transforming strings:  
```sql
SELECT list_transform(['Duck', 'Goose', 'Sparrow'], s -> concat(s, 'DB'));
```  
```text
[DuckDB, GooseDB, SparrowDB]
```  
Combining lambda functions with other functions:  
```sql
SELECT list_transform([5, NULL, 6], x -> coalesce(x, 0) + 1);
```  
```text
[6, 1, 7]
```