For AI agents: the complete documentation index is available at https://silt-db.dev/llms.txt, the full documentation bundle is available at https://silt-db.dev/llms-full.txt, and this page is available as Markdown at https://silt-db.dev/reference/queries.md.

    Query support

    Use the MongoDB query predicate reference for syntax and examples. This inventory records the operators supported by Silt; the compatibility page defines the shared data and API limits.

    FamilySupported names and restrictions
    Comparison$eq, $ne, $gt, $gte, $lt, $lte, $in, $nin; numeric/boolean separation, ordered embedded-object identity, nested arrays and type-bracketed ranges.
    Logical$and, $or, $nor, field $not; aggregation $expr predicates.
    Presence/type$exists; $type for number, string, object, array, bool, null and corresponding supported type codes. BSON int/long/double subtype tests are rejected.
    Arrays$all, $elemMatch, $size; multikey dotted traversal, indexed paths and Mongo-specific nested-array behavior. Query paths, expression paths, update paths and join keys use separate semantics.
    NumericInteger $mod; bit masks/positions within the documented representable range via $bitsAllSet, $bitsAllClear, $bitsAnySet, $bitsAnyClear. Arbitrary precision/binary bit fields are not supported.
    Regex by defaultLiterals, branch anchors, alternatives, dot, explicit/negated character classes, *, +, ? and flags m/s/u, compiled to stock SQLite. Captures, shorthand classes, lookaround, case-insensitive flags and unlisted syntax require the optional native mode; see the regex reference. JavaScript RegExp objects are not stored as BSON regex.
    Optional native regex$regex/$options with PCRE2 matching inside SQLite. Flags i, m, s, x, u, Unicode and PCRE syntax are tested. See native build and limits.
    Rejected families$where, $jsonSchema, geospatial/text/server-dependent predicates and unlisted operators.

    Field order matters for embedded-object equality. Missing/null matches and array traversal follow measured Mongo cases, including nested arrays. See testing and compatibility evidence for the measured cases.