We currently have a Postgres-based implementation. We should add a SQLite one. It should be gated behind a feature flag, named `sqlite`. The structure should follow the one for the current Postgres implementation.