Functions

NYXDB ships 865 native functions and supports a hot-loadable user-defined function runtime. Function versions are resolved by the binder and runtime registry, not the parser, so functions can be hot-loaded without parser changes.

This page documents the families with representative, verified function names. It is not the exhaustive catalog — query the running engine for that.

Aggregate

count, sum, avg, min, max, arg_min, arg_max, any, count_distinct, sum_if, string_agg, uniq_exact, range_agg.

SELECT market, count() AS trades, sum(amount) AS volume
FROM trades GROUP BY market;

Window

row_number, rank, dense_rank, lag, lead, first_value, last_value, cume_dist, percent_rank, nth_value.

Statistical

corr, covar_pop, stddev_samp, var_pop, percentile_cont, quantile_exact, median_t_digest, regr_slope.

Math & trigonometry

abs, ceil, floor, round, sqrt, cbrt, pow, log, gcd, lcm, factorial, pi, e; sin, cos, tan, asin, acos, atan, atan2, sinh, cosh, asinh.

String

concat, lower, upper, substring, substring_utf8, split_by_string, split_part, regexp_replace, trim, position, lpad_utf8, reverse.

Date / time

date_add, date_diff, date_bin, time_bucket, extract, format_datetime, parse_datetime64, to_start_of_hour, timestamp_diff, timezone_offset.

Array

array_append, array_concat, array_contains, array_map, array_sort, array_min, array_max, array_cum_sum, array_dot_product, array_slice, array_flatten, array_zip.

JSON

json_extract, json_path_query, json_set, json_insert, json_pretty, to_json, from_json, json_type, json_merge_patch, json_object_agg.

Vector / distance

cosine_distance, cosine_similarity, l2_distance, inner_product, dot_product, negative_inner_product.

SELECT id, cosine_distance(embedding, $q) AS d
FROM docs ORDER BY d LIMIT 10;

Type conversion

cast, to_int64, to_decimal256, to_ipv4, cast_as_text, reinterpret_as_float64, coalesce, null_if.

Hashing & crypto

md5, sha256, sha512_256, keccak256, blake3, crc32, hmac, murmur_hash3_64, xxh3.

Geospatial

geo_distance, great_circle_distance, h3_distance, h3_to_parent, h3_polygon_to_cells, s2_rect_contains, st_point_from_wkb.

Time series

running_difference, time_series_extract_tag, time_series_store_tags, time_series_id_to_tags, time_series_replace_tag.