How to make forbidden changes to SQLite tables

The article describes a method for making structural changes to SQLite tables that cannot be done with simple ALTER commands. It outlines a five-step process involving creating a new table with the desired structure, copying data, and renaming tables. The approach is demonstrated with a specific example of adding ON DELETE CASCADE to a foreign key constraint.