This is what I mean by New Versions Should be Substitutable
The intent of the developers is to support SQLite through the year 2050.
Most importantly:
the developers also promise to keep the SQLite C-language API and on-disk format fully backwards compatible
Read the whole thing on the SQLite official site. It should be the standard for libraries.