SQLite, EF Core 10
Same file back out
Round-tripping SQLite schemas: what a diagram lost and what was fixed
Schemity, a desktop ERD tool, read two real SQLite schemas, Campfire on Rails 8 and Jellyfin on EF Core 10, and rebuilt database files from the SQL it wrote. Before the fixes, declared column types, partial and expression indexes and AUTOINCREMENT settings were lost. The post is a useful case study for anyone who edits or migrates SQLite schemas with a tool.