Using alerts to simply email the result of a query

[pauljura]

I would like to be able to simply email myself the result of a query on a regular basis (e.g. once a day, once per hour, etc). Instead of making a new feature request, I can achieve this right now using alerts.

But I have 2 issues:

1. The alert requires a condition to be met. I can work around this now by adding a column with a value that will always be >=1
2. The email contents make it obvious that it's an alert, not simply a report. I am unable to set the email contents to be only the result of the query.

So here are some possible solutions:

1. Make a dedicated feature that is just for emailing the results of a query, or possibly the contents of an entire dashboard. This would be essentially identical to the current "alerts" feature, minus the setting for "Trigger when". The email contents would be just the query result.
2. Make a new template variable that is just the HTML contents of the query result. None of the existing template variables {{QUERY_RESULT_VALUE}} , {{QUERY_RESULT_ROWS}} , {{QUERY_RESULT_COLS}} , or {{QUERY_RESULT_TABLE}} will give me the results as a HTML table.

This is what I'd like the email to contain:

Your existing code is 90% of the way to giving me what I want. Hopefully this is easy to implement.

PS. I'm using Version: 24.08.1-dev (c1a60bf)