OPAL Misc Functions

Miscellaneous functions are those that do not fit in the other categories.

Function	Description
any_null	Returns a null value of type any.
coalesce	Return the first non-null argument or null if all are null.
editdistance	Returns the Levenshtein distance between str1 and str2.
frame	Specify the relative time frame for a window context.
frame_exact	Specify the relative time frame for a window context.
if	Return the second argument if condition# is true, otherwise return third argument.
if_null	Return the second argument if the first argument has the null value.
order_by	Specify the ordering when processing data.
parse_json	Parse the argument value as a JSON string.
position	Searches for the first occurrence of the second argument (needle) in the first argument (haystack) and, if successful, returns the
string	Generate a string representation of the argument value.
string_null	Returns a null value of type string.
variant_type_name	Given a variant value (typically, something you get from looking up a path or element in a JSON object or array,) determine what