Find all orders with pending status

MongoDB query compiled from plain English against the ecommerce sample schema, then verified by running it.

The compiled query

{
  "type": "find",
  "collection": "orders",
  "filter": {
    "status": "pending"
  }
}

How the compiled query works

Filters orders on status.

Example results

Live output from running this query against the sample dataset.

totalCents	status	placedAt	customerId	productIds
1400	pending	2026-08-02T06:36:46.195Z	6a703c7093006467161e36cd	["6a703c7093006467161e36d0"]

Write this in plain English instead. Mask Databases compiles the sentence above into exactly this query at build time — no AI at runtime, and you can read the output in a diff.

Try it in the playground → No signup, runs in your browser.

Find all orders with pending status

The compiled query

How the compiled query works

Example results

Related queries