> Design your application's hot path to never use joins

I had a Chief Architect you decreed this.

So engineers wound up doing joins in application code, with far worse performance, filtering, memory caching, etc.