SQLite will fail all further commands on a connection if the underlying schema has been modified.
Therefore,
any runtime changes requiring rescan also require us to re-connect to the database.
The rescan method here handles that reconnection for you,
but beware that this must occur for any other open sqlite connections as well.