How to print result of query execution in alerts, not only name of alert

I created alerts, it execute query and return in string ids which have such condition, i want that in email or whatever everyone can see the result of this query execution without click on query. Cause people who has not permissions need to get this result but has not , and they must not have permissions to look at code of query and change this or have redash

This is a feature that has been requested before (see below) and will be implemented as part of V9.

Also requested here: