Postgres can do more than you think

Window functions replaced so much application code for me. It's absurd how much people do in app code.

LATERAL joins too. Postgres quietly has everything.