Recursive CTEs, explained from first principles

Some data isn't flat. An employee has a manager, who has a manager, who has a manager, all the way...