This experiment has shown two things to me

1. ) it is possible to code quite complex algorithms in SQL, and often the SQL code is surprisingly pleasant, and
2. ) recursive SQL would be much more efficient and more pleasant to use if we had mechanisms to update state.