The first is support for common table expressions, which use the SQL WITH clause.
The basic WITH clause allows you to specify inline views that the query can use.
However, the WITH clause also supports a recursive mode that allows tables in the WITH clause to reference themselves.
Among other things, this allows you use a single query to load all descendents in a tree structure, something otherwise impossible in standard SQL.