Re:SQLite as an Application File Format (2014)
by bob1029 on Saturday June 13, 2020 @12:04PM
(#23510382)
It sounds like future schema changes may be a potential concern for your application. One thing you can look into using is the SQLite user_version pragma. We use this right now to roll our own migrators and it's light years better than how migrators work for Entity Framework, et. al.
https://www.sqlite.org/pragma.html#pragma_user_version