Unnesting Scalar Subqueries into Left Outer Joins in SQL in Aurora and PostgreSQL

Relational databases treat your query as a declarative description of the desired result and select...