Sketch
The way you've explained it's not necessary, I think.
For someone quiet lost in explanation own sketch might help.
Don't know if you've ever read 100 Years of Solitude from García Márquez, 7 generations of same family, a "ton" of people with the same name and surname, I have to read twice and make a sketch to not get lost lol.
Ok understood, it's mainly SQL.
I haven't read it, but I can imagine the problems that result :-)
My biggest read challenge so far!
Yes, it's mainly SQL, and we did spend a lot of effort speeding up that SQL code (as well as refactoring it for easier future development).
Great!