another option is hide the columns in the view. but still is preferable rewrite your querys.