QuackDB.List (quackdb v0.4.2)

Copy Markdown View Source

SQL expression helpers for DuckDB LIST/ARRAY values.

These helpers return iodata and map directly to DuckDB list functions. They are intentionally small building blocks for larger query modules.

Summary

Functions

Builds list_contains(list, value).

Builds list_has_all(left, right).

Builds list_has_any(left, right).

Builds unnest(list).

Functions

contains(list_expression, value_expression)

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

Builds list_contains(list, value).

has_all(left_expression, right_expression)

@spec has_all(iodata(), iodata()) :: iodata()

Builds list_has_all(left, right).

has_any(left_expression, right_expression)

@spec has_any(iodata(), iodata()) :: iodata()

Builds list_has_any(left, right).

unnest(list_expression)

@spec unnest(iodata()) :: iodata()

Builds unnest(list).