How does a Recursive CTE know to only process records added during the last iteration (and not looking at all of them)?
Consider this [v good] example from Using recursive CTE to generate a range of data
Consider this [v good] example from Using recursive CTE to generate a range of data