I think everyone tends to learn their own subset of SQL. I was unaware of some of the more 'obvious' solutions in the article (e.g. I had only a very vague idea of how window functions work), but I use lateral joins all the time.
The nice thing about lateral joins is that they're very easy to understand conceptually once you get over the weird syntax.