Custom SQL Events for Triggers

Having the ability to write custom Events for triggers instead of having to stick with the pre determined triggers.

For example, I would like a trigger when an asset goes out of service and back in service. Currently; with triggers that is not an option