I would like to see Acoustic to allow a query to be reused as a data source for other queries, this would be concept similar to a "veiw" in aRelational Database Management Systems.

Here is the problem I am trying to solve for.

• I have a single database with data from over 40 countries.

• I have created individual queries to segment by country and language.

• Using folder level permission, I have removed direct access to the database or the folder containing the main database.

  • Reason: I want force a user to us the presegmented query and not email to the entire database when sending an email

  • Downside: users with the permission to edit a Contact list are no-longer able to do so as they do not have access to the database.

The ability to have a saved query work like a “database view” as the view could be the source for other queries and contact lists would be very useful.

See support case : 00280291 Issues attempting to add a content to a contact list when the users permission are limited to a different database folder

Database View: https://docs.microsoft.com/en-us/sql/relational-databases/views/views?view=sql-server-ver15