array_append
the resulting array
Supported Signatures
function array_append(array, $1) returns array
🔗 Official Documentation
array_cat
Concatenate two arrays
Supported Signatures
function array_cat(array, array) returns array
function array_cat(variant, variant) returns array
function array_cat(array, variant) returns array
function array_cat(variant, array) returns array
🔗 Official Documentation
array_compact
Compact array by removing nulls
Supported Signatures
function array_compact(array) returns array
function array_compact(variant) returns array
🔗 Official Documentation
array_construct
the resulting array
Supported Signatures
function array_construct($1, ...) returns array
function array_construct($1, $2) returns array
function array_construct($1, $2, $3) returns array
function array_construct($1, $2, $3, $4) returns array
function array_construct($1, $2, $3, $4, $5) returns array
🔗 Official Documentation
array_construct_compact
the resulting array
Supported Signatures
function array_construct_compact($1, ...) returns array
🔗 Official Documentation
array_contains
Returns true if array contains value
Supported Signatures
function array_contains(variant, array) returns boolean
function array_contains($1, array) returns boolean
🔗 Official Documentation
array_distinct
the resulting array
Supported Signatures
function array_distinct(array) returns array
🔗 Official Documentation
array_except
the resulting array
Supported Signatures
function array_except(array, array) returns array
🔗 Official Documentation
array_flatten
the resulting array
Supported Signatures
function array_flatten(array) returns array
🔗 Official Documentation
array_generate_range
the resulting array
Supported Signatures
function array_generate_range(decimal(38, 0), decimal(38, 0)) returns array
function array_generate_range(decimal(38, 0), decimal(38, 0), decimal(38, 0)) returns array
🔗 Official Documentation
array_insert
the resulting array
Supported Signatures
function array_insert(array, decimal(38, 0), $1) returns array
🔗 Official Documentation
array_intersection
the resulting array
Supported Signatures
function array_intersection(array, array) returns array
🔗 Official Documentation
array_max
the maximum defined element in the array, or NULL
Supported Signatures
function array_max(array) returns variant
🔗 Official Documentation
array_min
the minimum defined element in the array, or NULL
Supported Signatures
function array_min(array) returns variant
🔗 Official Documentation
array_position
Returns the first index position of the element in the array
Supported Signatures
function array_position(variant, array) returns decimal(38, 0)
function array_position($1, array) returns decimal(38, 0)
🔗 Official Documentation
array_prepend
the resulting array
Supported Signatures
function array_prepend(array, $1) returns array
🔗 Official Documentation
array_remove
the resulting array
Supported Signatures
function array_remove(array, variant) returns array
function array_remove(array, $1) returns array
🔗 Official Documentation
array_remove_at
the resulting array
Supported Signatures
function array_remove_at(array, decimal(38, 0)) returns array
🔗 Official Documentation
array_size
Returns array size
Supported Signatures
function array_size(array) returns decimal(38, 0)
function array_size(variant) returns decimal(38, 0)
🔗 Official Documentation
array_slice
the resulting array
Supported Signatures
function array_slice(array, decimal(38, 0), decimal(38, 0)) returns array
🔗 Official Documentation
array_sort
the sorted array
Supported Signatures
function array_sort(array) returns array
function array_sort(array, boolean) returns array
function array_sort(array, boolean, boolean) returns array
🔗 Official Documentation
array_to_string
Convert array to a string
Supported Signatures
function array_to_string(array, varchar) returns varchar
function array_to_string(variant, varchar) returns varchar
🔗 Official Documentation
arrays_overlap
Returns true if two arrays have elements in common
Supported Signatures
function arrays_overlap(array, array) returns boolean
🔗 Official Documentation
arrays_to_object
the resulting object
Supported Signatures
function arrays_to_object(array, array) returns object
🔗 Official Documentation
as_array
Use VARIANT value as ARRAY
Supported Signatures
function as_array(variant) returns array
🔗 Official Documentation
as_binary
Use VARIANT value as binary string
Supported Signatures
function as_binary(variant) returns binary
🔗 Official Documentation
as_boolean
Use VARIANT value as Boolean
Supported Signatures
function as_boolean(variant) returns boolean
🔗 Official Documentation
as_char
Use VARIANT value as text string
Supported Signatures
function as_char(variant) returns varchar
🔗 Official Documentation
as_date
Use VARIANT value as DATE
Supported Signatures
function as_date(variant) returns date
🔗 Official Documentation
as_decimal
Use VARIANT value as decimal fixed-point
Supported Signatures
function as_decimal(variant) returns decimal(38, 0)
function as_decimal(variant, decimal(38, 0)) returns decimal(38, 0)
function as_decimal(variant, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
as_double
Use VARIANT value as real
Supported Signatures
function as_double(variant) returns double
🔗 Official Documentation
as_integer
Use VARIANT value as integer
Supported Signatures
function as_integer(variant) returns decimal(38, 0)
function as_integer(variant, decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
as_number
Use VARIANT value as as decimal fixed-point
Supported Signatures
function as_number(variant) returns decimal(38, 0)
function as_number(variant, decimal(38, 0)) returns decimal(38, 0)
function as_number(variant, decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
as_object
Use VARIANT value as OBJECT
Supported Signatures
function as_object(variant) returns object
🔗 Official Documentation
as_real
Use VARIANT value as real
Supported Signatures
function as_real(variant) returns double
🔗 Official Documentation
as_time
Use VARIANT value as TIME
Supported Signatures
function as_time(variant) returns time
🔗 Official Documentation
as_timestamp_ltz
Use VARIANT value as TIMESTAMP_LTZ
Supported Signatures
function as_timestamp_ltz(variant) returns timestamp
function as_timestamp_ltz(variant, decimal(38, 0)) returns timestamp
🔗 Official Documentation
as_timestamp_ntz
Use VARIANT value as TIMESTAMP_NTZ
Supported Signatures
function as_timestamp_ntz(variant) returns timestamp
function as_timestamp_ntz(variant, decimal(38, 0)) returns timestamp
🔗 Official Documentation
as_timestamp_tz
Use VARIANT value as TIMESTAMP_TZ
Supported Signatures
function as_timestamp_tz(variant) returns timestamp
function as_timestamp_tz(variant, decimal(38, 0)) returns timestamp
🔗 Official Documentation
as_varchar
Use VARIANT value as text sting
Supported Signatures
function as_varchar(variant) returns varchar
🔗 Official Documentation
check_json
Checks JSON for errors
Supported Signatures
function check_json(varchar) returns varchar
🔗 Official Documentation
check_xml
Checks XML for errors
Supported Signatures
function check_xml(varchar) returns varchar
function check_xml(varchar, boolean) returns varchar
🔗 Official Documentation
filter
Supported Signatures
function filter(array, function(variant, boolean)) returns array
🔗 Official Documentation
get
Get VARIANT element value from an array or object
Supported Signatures
function get(variant, varchar) returns variant
function get(variant, decimal(38, 0)) returns variant
function get(object, varchar) returns variant
function get(array, decimal(38, 0)) returns variant
function get(object, $1) returns variant
🔗 Official Documentation
get_ignore_case
Get VARIANT element value from an array or object with path name
Supported Signatures
function get_ignore_case(variant, varchar) returns variant
function get_ignore_case(object, varchar) returns $1
function get_ignore_case(object, $1) returns $1
🔗 Official Documentation
get_path
Get VARIANT element value from an array or object with path name
Supported Signatures
function get_path(variant, varchar) returns variant
function get_path(object, varchar) returns variant
function get_path(array, varchar) returns variant
🔗 Official Documentation
is_array
Returns true if VARIANT value is an array
Supported Signatures
function is_array(variant) returns boolean
🔗 Official Documentation
is_binary
Returns true if VARIANT value is a binary string
Supported Signatures
function is_binary(variant) returns boolean
🔗 Official Documentation
is_boolean
Returns true if VARIANT value is Boolean
Supported Signatures
function is_boolean(variant) returns boolean
🔗 Official Documentation
is_char
Returns true if VARIANT value is a text string
Supported Signatures
function is_char(variant) returns boolean
🔗 Official Documentation
is_date
Returns true if VARIANT value is a DATE
Supported Signatures
function is_date(variant) returns boolean
🔗 Official Documentation
is_date_value
Returns true if VARIANT value is a DATE
Supported Signatures
function is_date_value(variant) returns boolean
🔗 Official Documentation
is_decimal
Returns true if VARIANT value is a decimal fixed-point number
Supported Signatures
function is_decimal(variant) returns boolean
🔗 Official Documentation
is_double
Returns true if VARIANT value is a real number
Supported Signatures
function is_double(variant) returns boolean
🔗 Official Documentation
is_integer
Returns true if VARIANT value is integer
Supported Signatures
function is_integer(variant) returns boolean
🔗 Official Documentation
is_object
Returns true if VARIANT value is an object
Supported Signatures
function is_object(variant) returns boolean
🔗 Official Documentation
is_real
Returns true if VARIANT value is a real number
Supported Signatures
function is_real(variant) returns boolean
🔗 Official Documentation
is_time
Returns true if VARIANT value is a TIME
Supported Signatures
function is_time(variant) returns boolean
🔗 Official Documentation
is_timestamp_ltz
Returns true if VARIANT value is a TIMESTAMP_LTZ
Supported Signatures
function is_timestamp_ltz(variant) returns boolean
🔗 Official Documentation
is_timestamp_ntz
Returns true if VARIANT value is a TIMESTAMP_NTZ
Supported Signatures
function is_timestamp_ntz(variant) returns boolean
🔗 Official Documentation
is_timestamp_tz
Returns true if VARIANT value is a TIMESTAMP_TZ
Supported Signatures
function is_timestamp_tz(variant) returns boolean
🔗 Official Documentation
is_varchar
Returns true if VARIANT value is a text string
Supported Signatures
function is_varchar(variant) returns boolean
🔗 Official Documentation
Parses the first argument as a JSON and returns the value of the element pointed to by the second argument
Supported Signatures
function json_extract_path_text(varchar, varchar) returns varchar
🔗 Official Documentation
map_cat
Supported Signatures
function map_cat(object, object) returns object
🔗 Official Documentation
map_contains_key
Supported Signatures
function map_contains_key(varchar, object) returns boolean
🔗 Official Documentation
map_delete
Supported Signatures
function map_delete(object, varchar) returns object
function map_delete(object, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar, varchar) returns object
function map_delete(object, varchar, varchar, varchar, varchar, varchar) returns object
🔗 Official Documentation
map_insert
Supported Signatures
function map_insert(object, $1, $2) returns object
function map_insert(object, $1, $2, boolean) returns object
🔗 Official Documentation
map_keys
Supported Signatures
function map_keys(object) returns array
🔗 Official Documentation
map_pick
Supported Signatures
function map_pick(object, string) returns object
function map_pick(object, string, string) returns object
function map_pick(object, string, string, string) returns object
function map_pick(object, string, string, string, string) returns object
function map_pick(object, string, string, string, string, string) returns object
function map_pick(object, array) returns object
🔗 Official Documentation
map_size
Supported Signatures
function map_size(object) returns bigint
🔗 Official Documentation
object_construct
Supported Signatures
function object_construct(...) returns object
🔗 Official Documentation
object_construct_keep_null
the resulting object with null value
Supported Signatures
function object_construct_keep_null(...) returns object
🔗 Official Documentation
object_delete
the resulting OBJECT
Supported Signatures
function object_delete(object, varchar, ...) returns object
🔗 Official Documentation
object_insert
the resulting OBJECT
Supported Signatures
function object_insert(object, varchar, $1) returns object
function object_insert(object, varchar, $1, boolean) returns object
🔗 Official Documentation
object_keys
the resulting ARRAY
Supported Signatures
function object_keys(object) returns array
🔗 Official Documentation
object_pick
the resulting OBJECT
Supported Signatures
function object_pick(object, varchar, ...) returns object
function object_pick(object, array, ...) returns object
🔗 Official Documentation
parse_json
Parses string as a JSON document
Supported Signatures
function parse_json(varchar) returns variant
🔗 Official Documentation
parse_xml
Parses string as an XML document
Supported Signatures
function parse_xml(varchar) returns object
function parse_xml(varchar, boolean) returns object
function parse_xml() returns variant
🔗 Official Documentation
strip_null_value
Converts null values to SQL NULLs
Supported Signatures
function strip_null_value(variant) returns variant
🔗 Official Documentation
Supported Signatures
function transform(array, function(variant, variant)) returns array
🔗 Official Documentation
try_parse_json
Parses string as a JSON document
Supported Signatures
function try_parse_json(varchar) returns variant
🔗 Official Documentation
typeof
Returns SQL type word of a variant value
Supported Signatures
function typeof(variant) returns varchar
🔗 Official Documentation
xmlget
Get XML element object by XML tag name
Supported Signatures
function xmlget(variant, varchar, decimal(38, 0)) returns object
function xmlget(object, varchar, decimal(38, 0)) returns object
function xmlget(variant, varchar) returns object
function xmlget(object, varchar) returns object
🔗 Official Documentation
