MySQL & MSSQL View Triggers
In addition to normal old table triggers, Zapier now supports custom views! So if you have complex logic to trigger off of, it is simple to encapsulate in classic SQL views (which are just SELECT/WHERE expressions masquerading as normal tables!).