The Lateral Feature in PostgreSQL

It’s been around since PostgreSQL 9.3

Photo by Christina Morillo from Pexels

First off, the LATERAL isn’t a new feature in the world of PostgreSQL. This feature has been around since 2013.

The release of PostgreSQL 9.3 that year included this simple but nifty feature to supercharge subqueries and table joins. But as awesome as this feature was, it had no fanfare or buzz around it.