Hacker News new | ask | show | jobs
by nimajalali 2683 days ago
I’d add LATERAL JOINs to the list.

For those unaware of LATERAL JOINs, it’s like a for each loop in SQL. Blew my mind and opened up so many possibilities.