TIL: PostgreSQL supports LATERAL joins
M
mindweave26 viewsFebruary 28, 2026
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.