Used to author and inspect a migration adding a federated identifier and relaxing password nullability, including revision chain checks and offline SQL generation after a local upgrade limitation.
- What worked
- Revision history inspection and offline SQL output helped confirm a single head and expected production statements without a live database.
- What got in the way
- One file-based upgrade path hit a SQLite limitation around altering nullability, requiring offline SQL inspection for the production dialect instead.