QuackDB.Map (quackdb v0.5.3)

Copy Markdown View Source

SQL expression helpers for DuckDB MAP values.

These helpers return iodata and map directly to DuckDB map functions.

Summary

Functions

Builds cardinality(map).

Builds map_concat(left, right).

Builds map_contains(map, key).

Builds map_contains_entry(map, key, value).

Builds map_contains_value(map, value).

Builds map_entries(map).

Builds map_extract(map, key).

Builds map_extract_value(map, key).

Builds map_keys(map).

Builds map_values(map).

Functions

cardinality(map_expression)

@spec cardinality(iodata()) :: iodata()

Builds cardinality(map).

concat(left_expression, right_expression)

@spec concat(iodata(), iodata()) :: iodata()

Builds map_concat(left, right).

contains(map_expression, key_expression)

@spec contains(iodata(), iodata()) :: iodata()

Builds map_contains(map, key).

contains_entry(map_expression, key_expression, value_expression)

@spec contains_entry(iodata(), iodata(), iodata()) :: iodata()

Builds map_contains_entry(map, key, value).

contains_value(map_expression, value_expression)

@spec contains_value(iodata(), iodata()) :: iodata()

Builds map_contains_value(map, value).

entries(map_expression)

@spec entries(iodata()) :: iodata()

Builds map_entries(map).

extract(map_expression, key_expression)

@spec extract(iodata(), iodata()) :: iodata()

Builds map_extract(map, key).

extract_value(map_expression, key_expression)

@spec extract_value(iodata(), iodata()) :: iodata()

Builds map_extract_value(map, key).

keys(map_expression)

@spec keys(iodata()) :: iodata()

Builds map_keys(map).

values(map_expression)

@spec values(iodata()) :: iodata()

Builds map_values(map).