Hi Kelly, thanks for your feedback. There is no clear way to share why a query got flagged. this is mostly not about the query itself but about how it relates to past queries executed on that SQL DB.
Saying that, I do recognize the pain to clear the false positive and make it stop from re-firing. This could be done by turning TD off and than on again, it will clear all previous state and start learning the behavior from scratch. I do take your feedback we should make it clearer in the documentation.
If you have any feedback about the quality of the alerts you can use the feedback link in the alert to notify us and we will get back to you directly.
Thanks, Tomer (MSFT).
We are working on this exact feature. Will be ready in the next few months.
PowerShell support is coming in the next few months.