I couldn’t agree more. I used to to write complicated SQL-code when I started as an Analyst but soon had to find out that I could not read my own queries any more.

But another simple thing to keep your code readable is to just add comments. It is done in software engineering so why should SQL-developers not work with comments, too?