Rewrite iterative code in SQL if possible

The SQL abuser in me thinks this can be done in pure SQL, but we don't need to worry about that right now.  Should probably put a pin in that for later though.

_Originally posted by @a-frazier in https://github.com/AventurasTeam/Aventuras/pull/291#discussion_r3006387383_

---
[View on Discord](https://discord.com/channels/1456625039846805686/1494719381660238016/1494719381660238016)