#sql is nice, high level language they said. Focus on the meaning of the query ...

... and let the optimiser choose the right plan they said.
And then you extract part of the big query as a VIEW and suddenly the performance it 4x worse.