vercel / cosmosdb-query Goto Github PK

SELECT VALUE root
FROM root
WHERE (root["value"] = "value2")
OFFSET 0 LIMIT 1

{
  "message": "Expected \"!=\", \"%\", \"&\", \"*\", \"+\", \"-\", \"--\", \".\", \"/\", \"<\", \"<<\", \"<=\", \"<>\", \"=\", \">\", \">=\", \">>\", \">>>\", \"?\", \"??\", \"AND\", \"BETWEEN\", \"IN\", \"OR\", \"ORDER\", \"[\", \"^\", \"|\", \"||\", [ \\t\\n\\r], or end of input but \"O\" found.",
  "expected": [], // omitted for brevity
  "found": "O",
  "location": {
    "start": {
      "offset": 61,
      "line": 4,
      "column": 1
    },
    "end": {
      "offset": 62,
      "line": 4,
      "column": 2
    }
  },
  "name": "SyntaxError"
}

SELECT
  COUNT(1)
FROM (
  SELECT c.name
  FROM c
  WHERE
    c.name = 'READY'
) AS c

SELECT COUNT(1)
FROM (
  SELECT c.name
  FROM c
  WHERE (
    c.name = 'READY'
  )
  AS c
) AND (NOT IS_DEFINED(c.deletedAt) OR IS_NULL(c.deletedAt))

Expected ",", "--", "FROM", "ORDER", "WHERE", [ \t\n\r], [a-zA-Z0-9_], or end of input but "." found.

{
            id: '123',
            userId: uid,
            teamId: 'a',
            name: 'secret',
            value: 'abc'.toString('base64'),
            created: Date.now()
        }

SELECT * FROM c WHERE ARRAY_CONTAINS(@names, c.name)