id: "dtcs:stdlib.functions"
version: "3.0.0"
governingSpecification: "3.0.0"
publicationStatus: "standard"
entries:
dtcs:lower:
name: "Lower"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:upper:
name: "Upper"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:concat:
name: "Concat"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["string"],"returnType":"string","returnNullable":false,"deterministic":true,"nullBehavior":"propagate"}
dtcs:concat_ws:
name: "Concat With Separator"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["string"],"returnType":"string","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:substr:
name: "Substring"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:replace:
name: "Replace"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":3,"maxArgs":3,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:coalesce:
name: "Coalesce"
category: "function"
version: "2.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":null,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined","semantics":"firstPresent"}
dtcs:if_null:
name: "If Null"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:null_if:
name: "Null If"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:case_when:
name: "Case When"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["boolean","string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:try_cast:
name: "Try Cast"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsTarget","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:is_invalid:
name: "Is Invalid"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"boolean","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:length:
name: "Length"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","binary"],"returnType":"integer","returnNullable":false,"deterministic":true,"nullBehavior":"propagate"}
dtcs:to_string:
name: "To String"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:to_integer:
name: "To Integer"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","decimal","integer"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:to_decimal:
name: "To Decimal"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:abs:
name: "Absolute"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:round:
name: "Round"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:floor:
name: "Floor"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:ceil:
name: "Ceil"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:power:
name: "Power"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:sqrt:
name: "Square Root"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["decimal","integer"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:least:
name: "Least"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:greatest:
name: "Greatest"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:min:
name: "Min"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:max:
name: "Max"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:contains:
name: "Contains"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:starts_with:
name: "Starts With"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:ends_with:
name: "Ends With"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:is_null:
name: "Is Null"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"boolean","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:is_missing:
name: "Is Missing"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"boolean","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:count_all:
name: "Count All"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"aggregate","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"integer","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:count:
name: "Count"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"integer","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:count_distinct:
name: "Count Distinct"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"integer","returnNullable":false,"deterministic":true,"nullBehavior":"defined"}
dtcs:sum:
name: "Sum"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:average:
name: "Average"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined"}
dtcs:current_date:
name: "Current Date"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"date","returnNullable":false,"deterministic":false,"nullBehavior":"defined","runStable":true,"referenceClock":"2026-01-01"}
dtcs:current_timestamp:
name: "Current Timestamp"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"datetime","returnNullable":false,"deterministic":false,"nullBehavior":"defined","runStable":true,"timezone":"fixedOffset","referenceClock":"2026-01-01T00:00:00Z"}
dtcs:date_add:
name: "Date Add"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":3,"argTypes":["date","datetime","integer","string"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","units":["day","month","year","hour","minute"]}
dtcs:date_diff:
name: "Date Diff"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":3,"argTypes":["date","datetime","string"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","units":["day","month","year","hour","minute"]}
dtcs:date_trunc:
name: "Date Trunc"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":2,"argTypes":["date","datetime","string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:extract:
name: "Extract"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":2,"argTypes":["string","date","datetime"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate"}
dtcs:date_part:
name: "Date Part"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":2,"argTypes":["string","date","datetime"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","aliasOf":"dtcs:extract"}
dtcs:at_timezone:
name: "At Timezone"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"datetime","minArgs":2,"maxArgs":2,"argTypes":["datetime","string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","timezone":"fixedOffset"}
dtcs:row_number:
name: "Row Number"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"integer","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:rank:
name: "Rank"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"integer","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:dense_rank:
name: "Dense Rank"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"integer","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:lag:
name: "Lag"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":1,"maxArgs":3,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:lead:
name: "Lead"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":1,"maxArgs":3,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:first_value:
name: "First Value"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:last_value:
name: "Last Value"
category: "function"
version: "1.0.0"
status: "standard"
definition: |
{"kind":"function","family":"window","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/1"}
dtcs:ltrim:
name: "Left Trim"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:rtrim:
name: "Right Trim"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:trim:
name: "Trim Function"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:normalize_whitespace:
name: "Normalize Whitespace Function"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:split:
name: "Split"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string"],"returnType":"list<string>","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:join_strings:
name: "Join Strings"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list<string>","string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:pad_left:
name: "Pad Left"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:pad_right:
name: "Pad Right"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:repeat:
name: "Repeat"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string","integer"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:reverse:
name: "Reverse"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:position:
name: "Position"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_matches:
name: "Regex Matches"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_contains:
name: "Regex Contains"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_replace:
name: "Regex Replace"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":3,"maxArgs":3,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:cast:
name: "Cast"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer","decimal","boolean"],"returnType":"sameAsTarget","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:parse_decimal:
name: "Parse Decimal"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:parse_boolean:
name: "Parse Boolean"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:list:
name: "List Constructor"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":null,"argTypes":["string","integer","decimal","boolean","list","map","object"],"returnType":"list","returnNullable":false,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map:
name: "Map Constructor"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":null,"argTypes":["string","integer","decimal","boolean","list","map","object"],"returnType":"map","returnNullable":false,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:size:
name: "Collection Size"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["list","map","object","string"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:list_contains:
name: "List Contains"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:list_concat:
name: "List Concat"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["list"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map_keys:
name: "Map Keys"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["map","object"],"returnType":"list<string>","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map_values:
name: "Map Values"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["map","object"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:transform:
name: "Transform Values"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:filter_values:
name: "Filter Values"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:exists:
name: "Exists"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:forall:
name: "For All"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"boolean","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:to_timezone:
name: "To IANA Timezone"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["datetime","string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-temporal-iana/1","timezoneData":"iana"}
dtcs:from_utc:
name: "From UTC"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["datetime","string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-temporal-iana/1","timezoneData":"iana"}
dtcs:to_utc:
name: "To UTC"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":4,"argTypes":["datetime","string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-temporal-iana/1","timezoneData":"iana"}
dtcs:random:
name: "Random"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":1,"argTypes":["integer"],"returnType":"decimal","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-nondeterministic/1","randomAlgorithm":"xorshift64star/1"}
dtcs:random_normal:
name: "Normal Random"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":3,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-nondeterministic/1","randomAlgorithm":"xorshift64star/1"}
dtcs:uuid:
name: "UUID v4"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"string","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-nondeterministic/1","uuidVersion":4}
dtcs:run_id:
name: "Run Identifier"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"string","returnNullable":false,"deterministic":false,"runStable":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-nondeterministic/1"}
dtcs:run_timestamp:
name: "Run Timestamp"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"datetime","returnNullable":false,"deterministic":false,"runStable":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-nondeterministic/1"}
dtcs:translate:
name: "Translate"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":3,"maxArgs":3,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:lower_unicode:
name: "Lower Unicode"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:upper_unicode:
name: "Upper Unicode"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:casefold:
name: "Casefold"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_extract:
name: "Regex Extract"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_extract_all:
name: "Regex Extract All"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["string","integer"],"returnType":"list<string>","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:regex_split:
name: "Regex Split"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["string"],"returnType":"list<string>","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-string-advanced/1"}
dtcs:parse_date:
name: "Parse Date"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"date","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:parse_time:
name: "Parse Time"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"time","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:parse_datetime:
name: "Parse Datetime"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["string"],"returnType":"datetime","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-conversion/1"}
dtcs:format_date:
name: "Format Date"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["date","string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-conversion/1"}
dtcs:format_datetime:
name: "Format Datetime"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":2,"argTypes":["datetime","string"],"returnType":"string","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-conversion/1"}
dtcs:variance:
name: "Variance"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:stddev:
name: "Standard Deviation"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:covariance:
name: "Covariance"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":2,"maxArgs":2,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:correlation:
name: "Correlation"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":2,"maxArgs":2,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:median:
name: "Median"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:quantile:
name: "Quantile"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":2,"maxArgs":2,"argTypes":["integer","decimal"],"returnType":"decimal","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:first:
name: "First"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:last:
name: "Last"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:collect_list:
name: "Collect List"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary","list","map","object"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:collect_set:
name: "Collect Set"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","family":"aggregate","minArgs":1,"maxArgs":1,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-statistics/1"}
dtcs:object:
name: "Object Constructor"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":null,"argTypes":["string","integer","decimal","boolean","list","map","object"],"returnType":"object","returnNullable":false,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:tuple:
name: "Tuple Constructor"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":0,"maxArgs":null,"argTypes":["string","integer","decimal","boolean","list","map","object"],"returnType":"list","returnNullable":false,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:list_position:
name: "List Position"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["list"],"returnType":"integer","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:list_slice:
name: "List Slice"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":3,"argTypes":["list","integer"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:list_sort:
name: "List Sort"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["list"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map_entries:
name: "Map Entries"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["map"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map_from_entries:
name: "Map From Entries"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["list"],"returnType":"map","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:map_concat:
name: "Map Concat"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":null,"argTypes":["map"],"returnType":"map","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:object_names:
name: "Object Names"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["object"],"returnType":"list<string>","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:object_values:
name: "Object Values"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":1,"maxArgs":1,"argTypes":["object"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"propagate","profile":"dtcs:profile/portable-complex-values/1"}
dtcs:reduce:
name: "Reduce"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":3,"maxArgs":3,"argTypes":["list"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:zip_with:
name: "Zip With"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":3,"maxArgs":3,"argTypes":["list"],"returnType":"list","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:map_filter:
name: "Map Filter"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["map"],"returnType":"map","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:transform_keys:
name: "Transform Keys"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["map"],"returnType":"map","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:transform_values:
name: "Transform Values Map"
category: "function"
version: "1.0.0"
status: "experimental"
definition: |
{"kind":"function","minArgs":2,"maxArgs":2,"argTypes":["map"],"returnType":"map","returnNullable":true,"deterministic":true,"nullBehavior":"defined","profile":"dtcs:profile/portable-complex-values/1","lambdaSupport":true}
dtcs:ntile:
name: "Ntile"
category: "function"
version: "1.0.0"
status: "candidate"
definition: |
{"kind":"function","family":"window","minArgs":1,"maxArgs":1,"argTypes":["integer"],"returnType":"integer","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/2"}
dtcs:percent_rank:
name: "Percent Rank"
category: "function"
version: "1.0.0"
status: "candidate"
definition: |
{"kind":"function","family":"window","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"decimal","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/2"}
dtcs:cume_dist:
name: "Cumulative Distribution"
category: "function"
version: "1.0.0"
status: "candidate"
definition: |
{"kind":"function","family":"window","minArgs":0,"maxArgs":0,"argTypes":[],"returnType":"decimal","returnNullable":false,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/2"}
dtcs:nth_value:
name: "Nth Value"
category: "function"
version: "1.0.0"
status: "candidate"
definition: |
{"kind":"function","family":"window","minArgs":2,"maxArgs":2,"argTypes":["string","integer","decimal","boolean","date","time","datetime","duration","binary"],"returnType":"sameAsArgs","returnNullable":true,"deterministic":false,"nullBehavior":"defined","profile":"dtcs:profile/portable-window/2"}