Querying Data

FlintDB queries are JSON objects. Each query targets a collection and can include filtering, sorting, grouping, and aggregation.

Basic Query Structure

{
  "collection": "collectionName",
  "filter": { ... },
  "sort": { "field": "asc" | "desc" },
  "limit": 10,
  "select": ["field1", "field2"]
}

Filtering

Filter documents by field values:

{
  "collection": "orders",
  "filter": { "status": "shipped", "total": { "$gt": 100 } }
}

Filter Operators

Operator	Description
$gt	Greater than
$gte	Greater than or equal
$lt	Less than
$lte	Less than or equal
$ne	Not equal
$in	In array

Sorting

Sort results by one or more fields:

{
  "collection": "products",
  "sort": { "price": "desc" }
}

Grouping

Group documents and compute aggregates per group:

{
  "collection": "sales",
  "groupBy": "region",
  "aggregate": {
    "totalRevenue": { "sum": "amount" },
    "orderCount": { "count": true }
  }
}

Limiting Results

{
  "collection": "logs",
  "sort": { "timestamp": "desc" },
  "limit": 50
}