Great article :)
A strategy I found useful was making views out of very scary looking queries / queries with rather involved business logic. It can be tested/debugged and then be used for querying without further worries. Also, Postgres's \dv makes it easy to list views.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.