Cascade on delete not working on SQLite

Wappler Version : 5.3.1
Operating System : Windows 10
Server Model: NodeJS
Database Type: SQLite
Hosting Type: Wappler Local Server

Expected behavior

Deleting an entry also deletes the entries referencing it in its sub table when set to cascade on delete.

Actual behavior

The main entry is deleted but the entries in the sub table that reference it are unaffected.

How to reproduce

See - How to delete related sub tables when item is deleted?

and - How to delete related sub tables when item is deleted?