Hi Avi, thanks for the read and the comment.
I tried to simplify things by removing some details, but it ended up backfiring on me. 😅
I updated the post to expose a completely different schema that includes IDs and the N+1 problem. Hoping that clears it up a bit.