Here's my take on this, from a few months back:

https://materialize.com/lateral-joins-and-demand-driven-quer...