"If I recall correctly, the Fossil SCM uses SQLite under the covers for a lot of its stuff."

a fossil repository file is a .sqlite file yes

So SQLite is versioned in SQLite.

Makes sense, I haven't used the software in quite awhile.