We should enable certain pragma statements to be set on the connection object then, every time we open the connection, we should issue them as commands.

Here are a few interesting ones that ZSS recommends be set by default.

PRAGMA foreign_keys = ON;
PRAGMA recursive_triggers = ON;
PRAGMA journal_mode = WAL;