Currently it's not possible to amend the SELECT query in any way, it is fixed. It would be beneficial to be able to amend this for advanced alerting and reporting.
I don't understand this request - can you elaborate?
The SELECT query for any custom alert SQL/SWQL is fixed and can't be amended
