SQLite Long Term Support

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.