What is the difference between LATERAL JOIN and a subquery in PostgreSQL? What is the difference between LATERAL JOIN and a subquery in PostgreSQL? sql sql