Create New SQLite Adapter for OpenCodePublic

The user wanted to create a new version of an adapter that uses SQLite as the primary storage for the OpenCode project, while keeping the old version intact. The assistant developed the new adapter, ensured it falls back to the old storage method if needed, updated tests accordingly, and then committed and pushed the changes in logical stages to a new branch. This enabled local testing with the latest OpenCode nightly builds using the new SQLite-based storage.