[chasil]

It is an ANSI standard, implemented by many databases.

SQLite's trigger syntax appears to be conformant.

Transact SQL has much fewer implementations, and standards conformance enables interoperability. The SQL Server family is lacking in this respect.