chg: refactor adapter code to be async, functional and safe

The current code works, but it is very imperative and can potentially block transactions, because each query is executed synchronously, I recommend we wrap the query in a promise to give control back to the program while executing.

No file or test is named. Start by locating the adapter's synchronous query execution and inspect how the SQLite adapter implements the Cache Port. Done means the query path is asynchronous and does not block transactions while preserving the adapter's existing behavior.

由索引模型根据 Issue 内容生成。