Cosmos DB – List 1

Simple expressions

SELECT "Hello World"
SELECT "Hello World" AS greetings
SELECT VALUE "Hello World"
SELECT "Hello World", "Hello Space"
SELECT "Hello World" AS greetingsLocal, "Hello Space" AS greetingsAll

Objects / arrays shaping

SELECT ["Hello World", "Hello Space"] AS greetings
SELECT { "name": "Michal", "surname": "Jankowski" } as person
SELECT {
  "name": "Michal",
  "surname": "Jankowski",
  "roles": ["architect", "software developer", "team leader"]
} as person

String

SELECT
  CONCAT("Hello", " ", "World") AS Concat,
  LENGTH("Hello World") AS Length,
  LOWER("Hello World") AS Lower,
  UPPER("Hello World") AS Upper,
  LEFT("Hello World", 5) AS StrLeft,
  RIGHT("Hello World", 5) AS StrRight,
  SUBSTRING("Hello World", 4, 4) AS Substring,
  CONTAINS("Hello World", "ello") AS Contains,
  STARTSWITH("Hello World", "Hel") AS StartsWith,
  ENDSWITH("Hello World", "rld") AS EndsWith,
  INDEX_OF("Hello World", "World") AS IndexOf

Operators

SELECT
  "Hello" || " " || "World" AS StringConcat,
  10 * (2 - 11 % 5) / 3 AS Math,
  ("true" = "false" AND ("true" = "true" OR 1 = 1)) AS Logical,
  (1 > 0 ? "1 bigger than 0" : "1 not bigger than 0") AS Ternary,
  ("first" ?? undefined ?? "third") AS Coalesce

Math

SELECT
  PI() AS Pi,
  ABS(-5) AS Abs,
  ROUND(3.5) AS Round,
  CEILING(3.4) AS Ceiling,
  FLOOR(3.5) AS Floor,
  SIN(0) AS Sin,
  COS(0) AS Cos,
  TAN(0) AS Tan,
  LOG(100) AS Log

Arrays

SELECT
  ARRAY_CONCAT(["A", "B", "C"], ["1", "2", "3"], ["!", "@", "#"]) AS Concat,
  ARRAY_CONTAINS(["A", "B", "C"], "B") AS Contains,
  ARRAY_LENGTH(["A", "B", "C"]) AS Length,
  ARRAY_SLICE(["A", "B", "C", "D", "E"], 2, 2) AS Slice

Type checking

SELECT
  IS_NULL(":)") AS IsNull,
  IS_OBJECT("Hello") AS IsObject_False,
  IS_OBJECT({"name": "Michal", "surname": "Jankowski"}) AS IsObject_True,
  IS_BOOL("Hello") AS IsBool,
  IS_ARRAY(["Hi"]) AS IsArray