Skip to main content

FUNCTIONS_STRING

Constant FUNCTIONS_STRING 

Source
pub const FUNCTIONS_STRING: &str = "%YAML 1.2\n---\nurn: extension:io.substrait:functions_string\nscalar_functions:\n  -\n    name: concat\n    description: >-\n      Concatenate strings.\n\n      The `null_handling` option determines whether or not null values will be recognized by the function.\n      If `null_handling` is set to `IGNORE_NULLS`, null value arguments will be ignored when strings are concatenated.\n      If set to `ACCEPT_NULLS`, the result will be null if any argument passed to the concat function is null.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        variadic:\n          min: 1\n        options:\n          null_handling:\n            values: [ IGNORE_NULLS, ACCEPT_NULLS ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        variadic:\n          min: 1\n        options:\n          null_handling:\n            values: [ IGNORE_NULLS, ACCEPT_NULLS ]\n        return: \"string\"\n  -\n    name: like\n    description: >-\n      Are two strings like each other.\n\n      The `case_sensitivity` option applies to the `match` argument.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"match\"\n            description: The string to match against the input string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"match\"\n            description: The string to match against the input string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n  -\n    name: substring\n    description: >-\n      Extract a substring of a specified `length` starting from position `start`.\n      A `start` value of 1 refers to the first characters of the string.  When\n      `length` is not specified the function will extract a substring starting\n      from position `start` and ending at the end of the string.\n\n      The `negative_start` option applies to the `start` parameter. `WRAP_FROM_END` means\n      the index will start from the end of the `input` and move backwards.\n      The last character has an index of -1, the second to last character has an index of -2,\n      and so on. `LEFT_OF_BEGINNING` means the returned substring will start from\n      the left of the first character.  A `start` of -1 will begin 2 characters left of the\n      the `input`, while a `start` of 0 begins 1 character left of the `input`.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n          - value: i32\n            name: \"length\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING, ERROR ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n          - value: i32\n            name: \"length\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING, ERROR ]\n        return: \"string\"\n      - args:\n          - value: \"fixedchar<l1>\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n          - value: i32\n            name: \"length\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING, ERROR ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING ]\n        return: \"string\"\n      - args:\n          - value: \"fixedchar<l1>\"\n            name: \"input\"\n          - value: i32\n            name: \"start\"\n        options:\n          negative_start:\n            values: [ WRAP_FROM_END, LEFT_OF_BEGINNING ]\n        return: \"string\"\n  -\n    name: regexp_match_substring\n    description: >-\n      Extract a substring that matches the given regular expression pattern. The regular expression\n      pattern should follow the International Components for Unicode implementation\n      (https://unicode-org.github.io/icu/userguide/strings/regexp.html). The occurrence of the\n      pattern to be extracted is specified using the `occurrence` argument. Specifying `1` means\n      the first occurrence will be extracted, `2` means the second occurrence, and so on.\n      The `occurrence` argument should be a positive non-zero integer. The number of characters\n      from the beginning of the string to begin starting to search for pattern matches can be\n      specified using the `position` argument. Specifying `1` means to search for matches\n      starting at the first character of the input string, `2` means the second character, and so\n      on. The `position` argument should be a positive non-zero integer. The regular\n      expression capture group can be specified using the `group` argument. Specifying `0`\n      will return the substring matching the full regular expression. Specifying `1` will\n      return the substring matching only the first capture group, and so on. The `group`\n      argument should be a non-negative integer.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile, the occurrence value is out of range,\n      the position value is out of range, or the group value is out of range.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"occurrence\"\n          - value: i64\n            name: \"group\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"occurrence\"\n          - value: i64\n            name: \"group\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"string\"\n  -\n    name: regexp_match_substring\n    description: >-\n      Extract a substring that matches the given regular expression pattern. The regular expression\n      pattern should follow the International Components for Unicode implementation\n      (https://unicode-org.github.io/icu/userguide/strings/regexp.html). The first occurrence of the\n      pattern from the beginning of the string is extracted. It returns the substring matching the\n      full regular expression.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"string\"\n  -\n    name: regexp_match_substring_all\n    description: >-\n      Extract all substrings that match the given regular expression pattern. This will return a\n      list of extracted strings with one value for each occurrence of a match. The regular expression\n      pattern should follow the International Components for Unicode implementation\n      (https://unicode-org.github.io/icu/userguide/strings/regexp.html). The number of characters\n      from the beginning of the string to begin starting to search for pattern matches can be\n      specified using the `position` argument. Specifying `1` means to search for matches\n      starting at the first character of the input string, `2` means the second character, and so\n      on. The `position` argument should be a positive non-zero integer. The regular\n      expression capture group can be specified using the `group` argument. Specifying `0`\n      will return substrings matching the full regular expression. Specifying `1` will return\n      substrings matching only the first capture group, and so on. The `group` argument should\n      be a non-negative integer.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile, the position value is out of range,\n      or the group value is out of range.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"group\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"List<varchar<L1>>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"group\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"List<string>\"\n  -\n    name: starts_with\n    description: >-\n      Whether the `input` string starts with the `substring`.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n  -\n    name: ends_with\n    description: >-\n      Whether `input` string ends with the substring.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n  -\n    name: contains\n    description: >-\n      Whether the `input` string contains the `substring`.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"boolean\"\n  -\n    name: strpos\n    description: >-\n      Return the position of the first occurrence of a string in another string. The first\n      character of the string is at position 1. If no occurrence is found, 0 is returned.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L1>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to search for.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n  -\n    name: regexp_strpos\n    description: >-\n      Return the position of an occurrence of the given regular expression pattern in a\n      string. The first character of the string is at position 1. The regular expression pattern\n      should follow the International Components for Unicode implementation\n      (https://unicode-org.github.io/icu/userguide/strings/regexp.html). The number of characters\n      from the beginning of the string to begin starting to search for pattern matches can be\n      specified using the `position` argument. Specifying `1` means to search for matches\n      starting at the first character of the input string, `2` means the second character, and so\n      on. The `position` argument should be a positive non-zero integer. Which occurrence to\n      return the position of is specified using the `occurrence` argument. Specifying `1` means\n      the position first occurrence will be returned, `2` means the position of the second\n      occurrence, and so on. The `occurrence` argument should be a positive non-zero integer. If\n      no occurrence is found, 0 is returned.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile, the occurrence value is out of range, or\n      the position value is out of range.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"occurrence\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n          - value: i64\n            name: \"occurrence\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n  -\n    name: count_substring\n    description: >-\n      Return the number of non-overlapping occurrences of a substring in an input string.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to count.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to count.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"fixedchar<L2>\"\n            name: \"substring\"\n            description: The substring to count.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: i64\n  -\n    name: regexp_count_substring\n    description: >-\n      Return the number of non-overlapping occurrences of a regular expression pattern in an input\n      string. The regular expression pattern should follow the International Components for\n      Unicode implementation (https://unicode-org.github.io/icu/userguide/strings/regexp.html).\n      The number of characters from the beginning of the string to begin starting to search for\n      pattern matches can be specified using the `position` argument. Specifying `1` means to\n      search for matches starting at the first character of the input string, `2` means the\n      second character, and so on. The `position` argument should be a positive non-zero integer.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile or the position value is out of range.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n          - value: \"fixedchar<L2>\"\n            name: \"pattern\"\n          - value: i64\n            name: \"position\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n  -\n    name: regexp_count_substring\n    description: >-\n      Return the number of non-overlapping occurrences of a regular expression pattern in an input\n      string. The regular expression pattern should follow the International Components for\n      Unicode implementation (https://unicode-org.github.io/icu/userguide/strings/regexp.html).\n      The match starts at the first character of the input string.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: \"string\"\n            name: \"pattern\"\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: i64\n  -\n    name: replace\n    description: >-\n      Replace all occurrences of the substring with the replacement string.\n\n      The `case_sensitivity` option applies to the `substring` argument.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: Input string.\n          - value: \"string\"\n            name: \"substring\"\n            description: The substring to replace.\n          - value: \"string\"\n            name: \"replacement\"\n            description: The replacement string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: Input string.\n          - value: \"varchar<L2>\"\n            name: \"substring\"\n            description: The substring to replace.\n          - value: \"varchar<L3>\"\n            name: \"replacement\"\n            description: The replacement string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n        return: \"varchar<L1>\"\n  -\n    name: concat_ws\n    description: Concatenate strings together separated by a separator.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"separator\"\n            description: Character to separate strings by.\n          - value: \"string\"\n            name: \"string_arguments\"\n            description: Strings to be concatenated.\n        variadic:\n          min: 1\n        return: \"string\"\n      - args:\n          - value: \"varchar<L2>\"\n            name: \"separator\"\n            description: Character to separate strings by.\n          - value: \"varchar<L1>\"\n            name: \"string_arguments\"\n            description: Strings to be concatenated.\n        variadic:\n          min: 1\n        return: \"varchar<L1>\"\n  -\n    name: repeat\n    description: Repeat a string `count` number of times.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: i64\n            name: \"count\"\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: i64\n            name: \"count\"\n        return: \"varchar<L1>\"\n  -\n    name: reverse\n    description: Returns the string in reverse order.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        return: \"fixedchar<L1>\"\n  -\n    name: replace_slice\n    description: >-\n      Replace a slice of the input string.  A specified \'length\' of characters will be deleted from\n      the input string beginning at the \'start\' position and will be replaced by a new string.  A\n      start value of 1 indicates the first character of the input string. If start is negative\n      or zero, or greater than the length of the input string, a null string is returned. If \'length\'\n      is negative, a null string is returned.  If \'length\' is zero, inserting of the new string\n      occurs at the specified \'start\' position and no characters are deleted. If \'length\' is\n      greater than the input string, deletion will occur up to the last character of the input string.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: Input string.\n          - value: i64\n            name: \"start\"\n            description: The position in the string to start deleting/inserting characters.\n          - value: i64\n            name: \"length\"\n            description: The number of characters to delete from the input string.\n          - value: \"string\"\n            name: \"replacement\"\n            description: The new string to insert at the start position.\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: Input string.\n          - value: i64\n            name: \"start\"\n            description: The position in the string to start deleting/inserting characters.\n          - value: i64\n            name: \"length\"\n            description: The number of characters to delete from the input string.\n          - value: \"varchar<L2>\"\n            name: \"replacement\"\n            description: The new string to insert at the start position.\n        return: \"varchar<L1>\"\n  -\n    name: lower\n    description: >-\n      Transform the string to lower case characters. Implementation should follow the utf8_unicode_ci\n      collations according to the Unicode Collation Algorithm described at http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: upper\n    description: >-\n      Transform the string to upper case characters. Implementation should follow the utf8_unicode_ci\n      collations according to the Unicode Collation Algorithm described at http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: swapcase\n    description: >-\n      Transform the string\'s lowercase characters to uppercase and uppercase characters to\n      lowercase. Implementation should follow the utf8_unicode_ci collations according to the\n      Unicode Collation Algorithm described at http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: capitalize\n    description: >-\n      Capitalize the first character of the input string. Implementation should follow the\n      utf8_unicode_ci collations according to the Unicode Collation Algorithm described at\n      http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: title\n    description: >-\n      Converts the input string into titlecase. Capitalize the first character of each word in the\n      input string except for articles (a, an, the). Implementation should follow the\n      utf8_unicode_ci collations according to the Unicode Collation Algorithm described at\n      http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: initcap\n    description: >-\n      Capitalizes the first character of each word in the input string, including articles,\n      and lowercases the rest. Implementation should follow the utf8_unicode_ci collations\n      according to the Unicode Collation Algorithm described at http://www.unicode.org/reports/tr10/.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        options:\n          char_set:\n            values: [ UTF8, ASCII_ONLY ]\n        return: \"fixedchar<L1>\"\n  -\n    name: char_length\n    description: >-\n      Return the number of characters in the input string.  The length includes trailing spaces.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        return: i64\n  -\n    name: bit_length\n    description: Return the number of bits in the input string.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        return: i64\n  -\n    name: octet_length\n    description: Return the number of bytes in the input string.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n        return: i64\n      - args:\n          - value: \"fixedchar<L1>\"\n            name: \"input\"\n        return: i64\n  -\n    name: regexp_replace\n    description: >-\n      Search a string for a substring that matches a given regular expression pattern and replace\n      it with a replacement string. The regular expression pattern should follow the\n      International Components for Unicode implementation (https://unicode-org.github\n      .io/icu/userguide/strings/regexp.html). The occurrence of the pattern to be replaced is\n      specified using the `occurrence` argument. Specifying `1` means only the first occurrence\n      will be replaced, `2` means the second occurrence, and so on. Specifying `0` means all\n      occurrences will be replaced. The number of characters from the beginning of the string to\n      begin starting to search for pattern matches can be specified using the `position` argument.\n      Specifying `1` means to search for matches starting at the first character of the input\n      string, `2` means the second character, and so on. The `position` argument should be a\n      positive non-zero integer. The replacement string can capture groups using numbered\n      backreferences.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines.  This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile, the replacement contains an illegal\n      back-reference, the occurrence value is out of range, or the position value is out of range.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"pattern\"\n            description: The regular expression to search for within the input string.\n          - value: \"string\"\n            name: \"replacement\"\n            description: The replacement string.\n          - value: i64\n            name: \"position\"\n            description: The position to start the search.\n          - value: i64\n            name: \"occurrence\"\n            description: Which occurrence of the match to replace.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"string\"\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n            description: The regular expression to search for within the input string.\n          - value: \"varchar<L3>\"\n            name: \"replacement\"\n            description: The replacement string.\n          - value: i64\n            name: \"position\"\n            description: The position to start the search.\n          - value: i64\n            name: \"occurrence\"\n            description: Which occurrence of the match to replace.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"varchar<L1>\"\n  -\n    name: regexp_replace\n    description: >-\n      Search a string for a substring that matches a given regular expression pattern and replace\n      it with a replacement string. The regular expression pattern should follow the\n      International Components for Unicode implementation (https://unicode-org.github\n      .io/icu/userguide/strings/regexp.html). The replacement string can capture groups using numbered\n      backreferences. All occurrences of the pattern will be replaced. The search for matches\n      start at the first character of the input.\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines.  This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n\n      Behavior is undefined if the regex fails to compile or the replacement contains an illegal\n      back-reference.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"pattern\"\n            description: The regular expression to search for within the input string.\n          - value: \"string\"\n            name: \"replacement\"\n            description: The replacement string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"string\"\n  -\n    name: ltrim\n    description: >-\n      Remove any occurrence of the characters from the left side of the string.\n      If no characters are specified, spaces are removed.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"varchar<L2>\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"string\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"string\"\n  -\n    name: rtrim\n    description: >-\n      Remove any occurrence of the characters from the right side of the string.\n      If no characters are specified, spaces are removed.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"varchar<L2>\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"string\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"string\"\n  -\n    name: trim\n    description: >-\n      Remove any occurrence of the characters from the left and right sides of\n      the string. If no characters are specified, spaces are removed.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"varchar<L2>\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to remove characters from.\"\n          - value: \"string\"\n            name: \"characters\"\n            description: \"The set of characters to remove.\"\n        return: \"string\"\n  -\n    name: lpad\n    description: >-\n      Left-pad the input string with the string of \'characters\' until the specified length of the\n      string has been reached. If the input string is longer than \'length\', remove characters from\n      the right-side to shorten it to \'length\' characters. If the string of \'characters\' is longer\n      than the remaining \'length\' needed to be filled, only pad until \'length\' has been reached.\n      If \'characters\' is not specified, the default value is a single space.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"varchar<L2>\"\n            name: \"characters\"\n            description: \"The string of characters to use for padding.\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"string\"\n            name: \"characters\"\n            description: \"The string of characters to use for padding.\"\n        return: \"string\"\n  -\n    name: rpad\n    description: >-\n      Right-pad the input string with the string of \'characters\' until the specified length of the\n      string has been reached. If the input string is longer than \'length\', remove characters from\n      the left-side to shorten it to \'length\' characters. If the string of \'characters\' is longer\n      than the remaining \'length\' needed to be filled, only pad until \'length\' has been reached.\n      If \'characters\' is not specified, the default value is a single space.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"varchar<L2>\"\n            name: \"characters\"\n            description: \"The string of characters to use for padding.\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"string\"\n            name: \"characters\"\n            description: \"The string of characters to use for padding.\"\n        return: \"string\"\n  -\n    name: center\n    description: >-\n      Center the input string by padding the sides with a single `character` until the specified\n      `length` of the string has been reached. By default, if the `length` will be reached with\n      an uneven number of padding, the extra padding will be applied to the right side.\n      The side with extra padding can be controlled with the `padding` option.\n\n      Behavior is undefined if the number of characters passed to the `character` argument is not 1.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"varchar<L1>\"\n            name: \"character\"\n            description: \"The character to use for padding.\"\n        options:\n          padding:\n            values: [ RIGHT, LEFT ]\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"The string to pad.\"\n          - value: i32\n            name: \"length\"\n            description: \"The length of the output string.\"\n          - value: \"string\"\n            name: \"character\"\n            description: \"The character to use for padding.\"\n        options:\n          padding:\n            values: [ RIGHT, LEFT ]\n        return: \"string\"\n  -\n    name: left\n    description: Extract `count` characters starting from the left of the string.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: i32\n            name: \"count\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: i32\n            name: \"count\"\n        return: \"string\"\n  -\n    name: right\n    description: Extract `count` characters starting from the right of the string.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n          - value: i32\n            name: \"count\"\n        return: \"varchar<L1>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n          - value: i32\n            name: \"count\"\n        return: \"string\"\n  -\n    name: string_split\n    description: >-\n      Split a string into a list of strings, based on a specified `separator` character.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"separator\"\n            description: A character used for splitting the string.\n        return: \"List<varchar<L1>>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"separator\"\n            description: A character used for splitting the string.\n        return: \"List<string>\"\n  -\n    name: regexp_string_split\n    description: >-\n      Split a string into a list of strings, based on a regular expression pattern.  The\n      substrings matched by the pattern will be used as the separators to split the input\n      string and will not be included in the resulting list. The regular expression\n      pattern should follow the International Components for Unicode implementation\n      (https://unicode-org.github.io/icu/userguide/strings/regexp.html).\n\n      The `case_sensitivity` option specifies case-sensitive or case-insensitive matching.\n      Enabling the `multiline` option will treat the input string as multiple lines. This makes\n      the `^` and `$` characters match at the beginning and end of any line, instead of just the\n      beginning and end of the input string. Enabling the `dotall` option makes the `.` character\n      match line terminator characters in a string.\n    impls:\n      - args:\n          - value: \"varchar<L1>\"\n            name: \"input\"\n            description: The input string.\n          - value: \"varchar<L2>\"\n            name: \"pattern\"\n            description: The regular expression to search for within the input string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"List<varchar<L1>>\"\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: The input string.\n          - value: \"string\"\n            name: \"pattern\"\n            description: The regular expression to search for within the input string.\n        options:\n          case_sensitivity:\n            values: [ CASE_SENSITIVE, CASE_INSENSITIVE, CASE_INSENSITIVE_ASCII ]\n          multiline:\n            values: [ MULTILINE_DISABLED, MULTILINE_ENABLED ]\n          dotall:\n            values: [ DOTALL_DISABLED, DOTALL_ENABLED ]\n        return: \"List<string>\"\n\naggregate_functions:\n\n  -\n    name: string_agg\n    description: Concatenates a column of string values with a separator.\n    impls:\n      - args:\n          - value: \"string\"\n            name: \"input\"\n            description: \"Column of string values.\"\n          - value: \"string\"\n            name: \"separator\"\n            constant: true\n            description: \"Separator for concatenated strings\"\n        ordered: true\n        return: \"string\"\n";
Expand description

Included source of the functions_string extension YAML file.