It seems to me the view would have to store the query and apply a where clause to it, so the same PK would be in play.
It has data leaking properties. It has more use cases as it can be used to * construct views that filter out sensitive columns * apply transforms to convert units of measure Are there more thoughts along this line?