OPAL Misc Functions

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

Function	Description
any_null	Returns a null value of type any.
asc	Specify the ordering as ascending when processing data.
coalesce	Return the first non-null argument or null if all are null.
desc	Specify the ordering as descending when processing data.
editdistance	Returns the Levenshtein distance between str1 and str2.
frame	Specify the approximate relative time frame for a window context.
frame_exact	Specify the exact relative time frame for a window context.
if	Return the second argument if the condition is true, otherwise return the third argument.
if_null	Return the second argument if the first argument has the null value.
make_object	Turn a sequence of name:value elements into an object.
on	on is a special function used to specify the join condition for some join verbs.
order_by	Specify the ordering when processing data.
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