substring

substring(str, pos[, len]) – Returns the substring of `str` that starts at `pos` and is

struct

struct(col1, col2, col3, …) – Creates a struct with the given field values. Platforms: WhereOS,

string

string(expr) – Casts the value `expr` to the target data type `string`. Platforms: WhereOS, Spark,

subarray

subarray(array values, int offset [, int length]) – Slices the given array by the given

subarray_endwith

subarray_endwith(array original, int|text key) – Returns an array that ends with the specified key SELECT

stddev_samp

stddev_samp(expr) – Returns the sample standard deviation calculated from values of a group. Platforms: WhereOS,