TIL: PostgreSQL supports LATERAL joins

LATERAL joins let you reference columns from preceding tables in the FROM clause. Super useful for correlated subqueries that need to run per-row. Think of it like a for-each loop in SQL.