Playground

10,000 orders in an in-browser SQLite database, queried by the real engine.

Newest orders first, with status and category facets. Click a facet, a header or a row and watch the request and the SQL change. Docs →

What your users see signed in to acme
1 / 1

Click a row for its order lines. ⇧ click a header to sort by a second key. Products is locked: the resource disables sorting on it.

Under the hood

What the client sends, inside the server call. Lines that changed with your last action are marked.

await orders.query({  context: { orgId: "acme" }, // from your session, never the body  summary: true,  request: {    pagination: {      mode: "offset",      pageIndex: 1,      pageSize: 10,      count: "exact"    },    sorting: [      {        key: "createdAt",        dir: "desc"      }    ],    search: {      value: "",      fields: []    },    filters: [],    facets: [      {        key: "status",        mode: "exclude-self",        limit: 10      },      {        key: "orderLines.product.category",        mode: "exclude-self",        limit: 10      }    ]  }});