feat(solid-query): rewrite the adapter onto Solid 2's native async model

No fixes have been suggested for this run group yet. See the Self-Healing CI docs for how fixes are suggested.