Master recursive CTEs for hierarchical data. Trace paths up and down supply chains, calculate aggregate metrics across branches, and identify critical nodes. One table, one foreign key, infinite possibilities.