SQLite Forum

cycle detection in CHECK constraint with recursive CTE
> Most DBMS's implement immediate Foreign-Keys by default, unlike SQLite. 

> With deferred FKs, the only mode in SQLite...

No, immediate is the default and you have to specify "deferrable initially deferred" to get deferred FKs.

[Deferred Foreign Key Constraints](https://www.sqlite.org/foreignkeys.html#fk_deferred)

(Or I'm just misunderstanding what you're saying)