Used the ORM to add canonical URL fields and a per-field specification table with provenance, plus an in-place schema upgrade for the shipped database. Modeling and queries were straightforward.
- What worked
- Declarative models and metadata inspection made the additive migration and upsert logic easy to express. Existing stock data remained intact during upgrades.
- What got in the way
- Date handling needed extra care when values read back from storage had different timezone awareness, which surfaced during re-upsert testing.