Well, I checked BOL for both WHERE clause syntax and SELECT subquery, and neither shows this "feature".

Under the WHERE clause syntax, it simply shows the option to use a (subquery) , a couple variations, like EXISTS (subquery), which to me, implies a syntactically-correct subquery.