We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Some SQL dialects have special syntax for creating and manipulating Array and Map types.
Array literals [1, "two", 3]. Supported by:
[1, "two", 3]
Array literals ARRAY[1, 2, 3]. Supported by:
ARRAY[1, 2, 3]
Map literals in JSON style {"foo": 1, "bar": "John"}. Supported by:
{"foo": 1, "bar": "John"}
Array and Map access using square brackets like arr[1] and map['key'].
arr[1]
map['key']
Supported by:
Array subscript operator arr[OFFSET(5)]. Supported by:
arr[OFFSET(5)]