That’s a good catch. I’d there any way to tell which version of SQLite created the file? Aside from trial and error, I mean?
I haven't looked but there will be some sqlite command to query it and I'm sure some viewer tools will display it as well.
$ python -c 'import sys, struct; print(struct.unpack(">I", open(sys.argv[1], "rb").read()[96:100])[0])' foo.db $ file example.db
example.db: SQLite 3.x database, last written using SQLite version 3007017