Query with only certain columns

Is there a way to view/query only some columns of a table to be visible to a group of users? I have a table where some columns contain sensitive information, and I want to share a tabular view of of the non-sensitive information to regular users. I looked into subtables, reports and queries, none of them seem to fulfill this condition that would be a simple SQL query.

You can design multiple versions of the sheet to have different design / layout and set up fixed filter if necessary.