Here we start to get close to analytics sql vs application sql, and I think that's a whole separate beast itself with different patterns and anti-patterns.

Ah, yeah, you beat me to it. I do reporting, not applications.