SQL
Scoping
Lambda functions confirm to scoping rules in the following order:  
* inner lambda parameters
* outer lambda parameters
* column names
* macro parameters  
```sql
CREATE TABLE tbl (x INTEGER);
INSERT INTO tbl VALUES (10);
SELECT apply([1, 2], x -> apply([4], x -> x + tbl.x)[1] + x) FROM tbl;
```  
```text
[15, 16]
```