Wildcard query

[vwkd]

It would be great if kv-toolbox could add support for wildcard or glob queries.

They are useful to get specific data from a nested key space.

For example, they could enable a query like this to get the names of all users.

db.list({ prefix: ["users", "*", "name"] })

Related: denoland/deploy_feedback#415

[kitsonk]

The query functionality goes part of the way there:

import { query } from "@kitsonk/kv-toolbox/query";
const db = await Deno.openKv();
const result = query(db, { prefix: [] })
  .where("age", "<=", 10)
  .get();
for await (const entry of result) {
  console.log(entry);
}
db.close();

But it doesn't include key type querying. I suspect something like this would be possible:

import { query } from "@kitsonk/kv-toolbox/query";
const db = await Deno.openKv();
const result = query(db, { prefix: ["users"] })
  .key("glob", ["*", "name"])
  .get();
for await (const entry of result) {
  console.log(entry);
}
db.close();

or

import { query } from "@kitsonk/kv-toolbox/query";
const db = await Deno.openKv();
const result = query(db, { prefix: [] })
  .key("glob", ["users", "*", "name"])
  .get();
for await (const entry of result) {
  console.log(entry);
}
db.close();

I would want to keep the prefix syntax of the query() which makes it compatible with the underlying Deno.Kv.prototype.list which it has to leverage.