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.