> The code is part of a trigger with a trigger on a view. <https://www.sqlite.org/lang_createtrigger.html> "Syntax Restrictions On UPDATE, DELETE, and INSERT Statements Within Triggers ... Common table expression are not supported for statements inside of triggers."