Hello,

Does SQLite follow the standard where triggers in a given category are fired in the order they are created? I am having trouble determining (SQLite 3.31.1/Ubuntu 20.04) but my attempts so far are pointing in the direction of no.

Is there a way to get triggers to fire in a desired order? À la Postgres naming them alphabetically? The alternative looks like creating one trigger for each phase/WHEN condition and piling all salient statements into those.

Alternatively, is there a trick or scheme to the ordering of triggers that I am missing?