router.query(adapter) needs an adapter with an execute(query) function (a DFQL/DuckDB adapter or a pushdown source); nothing was fetched.

Warnings reference › data-router:bad-query-source

Identifier

data-router:bad-query-source

Raised by

Data Router

Since

1.33.0

What happened

router.query() pushes a query down to an adapter and fans the result through the ordinary route machinery. The object passed has no execute, so there was nothing to call: the promise resolves with the router unchanged and no rows were fetched.

The fix

Pass a pushdown adapter - the DFQL or DuckDB adapter, or your own object with execute(query, request) and optional capabilities.

The smallest fix

await router.query(duckdbAdapter, { filters, sort });

Reference

Covered in full at the API reference.