QuackDB.Struct (quackdb v0.5.3)

SQL expression helpers for DuckDB STRUCT values.

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

Summary

Functions

concat(left_expression, right_expression)

Builds struct_concat(left, right).

contains(struct_expression, value_expression)

Builds struct_contains(struct, value).

extract(struct_expression, field_or_index_expression)

Builds struct_extract(struct, field_or_index).

extract_at(struct_expression, index_expression)

Builds struct_extract_at(struct, index).

position(struct_expression, value_expression)

Builds struct_position(struct, value).

values(struct_expression)

Builds struct_values(struct).

Functions

concat(left_expression, right_expression)

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

Builds struct_concat(left, right).

contains(struct_expression, value_expression)

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

Builds struct_contains(struct, value).

extract(struct_expression, field_or_index_expression)

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

Builds struct_extract(struct, field_or_index).

extract_at(struct_expression, index_expression)

@spec extract_at(iodata(), iodata()) :: iodata()

Builds struct_extract_at(struct, index).

position(struct_expression, value_expression)

@spec position(iodata(), iodata()) :: iodata()

Builds struct_position(struct, value).

values(struct_expression)

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

Builds struct_values(struct).