Function open 

pub fn open(path: &str) -> Result<Connection, SqliteStoreError>

Open a file-backed SQLite connection at path, apply mandatory PRAGMAs, then run any pending migrations.

This is the production path for per-agent_id databases (one file per agent).