Why Many Architects Ban SQL Queries That Join More Than Three Tables

Lessons from an interview: Join algorithms and why “just write one big SQL query” is often a bad idea.