Everything above is an anecdote that happened to me personally when I pointed a SQLite client at chat.db on my Mac.