Advanced Alerts and SQL

You can create Advanced SQL variables to retrieve information from the database to be included in your notifications...  As far as writing a query as an alert trigger/reset/suppression this is not an available option.  Though, when you create an advanced alert the logic you are using in your conditions is translated in to an sql query on the back end and stored in the AlertDefinitions Table so once you have selected your alert crietria you can use that table and more specifically the Trigger/reset/suppression field in that table, to see the query that was created in your alert.