Resharper looks amazing ... pity I don't write anything much in the way of APP code ... (doesn't analyse SQL unless I missed something on their website?)
A solution?? is to prefix all columns (in SELECT list) with an alias. I don't do that though (as our column names are unique within the database, so only ambiguous if we self-reference a table)