SQLite `TRUNCATE` is invalid

[larsewi]

SQLite has no TRUNCATE; full-state apply will fail on the canonical backend. Emit DELETE FROM or gate by backend.