SQLite Forum

CTEs in triggers
Login
If that is the case, perhaps the documentation should be reworded for clarity, as  "not supported" can read "does not ever work". Indeed, `WITH` before an `INSERT` statement in a trigger results in a syntax error. I was surprised when the above workaround ran.

Is the restriction of CTEs in triggers due to difficulty parsing them or because it "may do something strange and undesirable under some conditions"? If so, which?