Comment by mhd

Lateral Joins

Recursive Queries (+ generating JSON from them)

Advanced Index Types

(Ab-)using arrays & custom types (contrast with JSON(B) for everything)