It could be helpful, especially for automating deploying alerts between environments.
As a workaround, I see the solution to at least maintain query via API, which is possible now, and to have a more general question as in the databricks example:
SELECT CASE WHEN drafts_count > 10000 AND archived_count > 5000 THEN 1 ELSE 0 END
FROM (
SELECT sum(CASE WHEN is_archived THEN 1 ELSE 0 END) AS archived_count,
sum(CASE WHEN is_draft THEN 1 ELSE 0 END) AS drafts_count
FROM queries) data