Class QueryBuilder

Simple example showing a basic set of where's (&& together) to get documents with a value between (inclusive) 40 and 50

const query = QueryBuilder
  .where('myKey', '>=' 40)
  .where('myKey', '<=', 50)

Using the orWhere function to generate OR queries

const query = QueryBuilder
  .orWhere(or => or
    .where('myKey', '===', true)
    .where('mySecondKey', '===', 52, true)
  )

-- The equivalent SQL query would be as follows --
SELECT
  *
FROM
  collection
WHERE
  myKey = TRUE
  AND mySecondKey != 52

Nested AND queries in an OR query

const query = QueryBuilder
  .orWhere(or => or
    .andWhere(
      and => and
        .where('key1', '===', 21)
        .where('key2', '===', 'boop')
    )
    .andWhere(
      and => and
        .where('key3', '>=', 1)
        .where('key4', '<=', 100)
    )
  )

// The above is kind of like the following if statement
if(
  (
    key1 === 21 &&
    key2 === 'boop'
  ) ||
  (
    key3 >= 1 &&
    key4 <= 100
  )
)

-- Or like the following SQL query --
SELECT
  *
FROM
  collection
WHERE
  (
    key1 = 21
    AND key2 = 'boop'
  )
  OR (
    key3 >= 1
    AND key4 <= 100
  )