With 4.1, correlated subqueries are here!
Please see this article for how you can leverage this for your own use cases: