The recursive_triggers pragma gets or sets the
recursive trigger functionality. If recursive triggers are not
enabled, a trigger action will not fire another trigger.
For many years, SQLite did not support recursive triggers. When they were added, the default for this pragma was set to off, in an effort to keep the default settings backwards compatible. The default version of this pragma may change in a future version of SQLite.