[mdcurran]

This doesn’t totally solve the issue of SELECT’ing first then filtering, but for complex queries I’ve found CTEs very useful (whenever the database/SQL dialect supports it).

[icedchai]

What I usually do is start with "select *", get the joins and where clause down, then refine the select.