Don't use *. It is a common source for all kinds of problems. Many query langs does not support it at all for that reason.
I'm quite aware of your advice regarding using `*` against tables. However, I'm talking about using `*` against subqueries and CTEs where the pieces of the table have already been extracted.
I was unable to edit this earlier due to HN being unavailable after I realized the formatter mangled it.