https://news.ycombinator.com/item?id=8690389
But they are similar... Kind of like correlated subqueries in the from clause. But they allow a few new twists in the semantics.