QuackDB.DML (quackdb v0.4.0)

Small DuckDB DML SQL builders.

These helpers return SQL iodata for setup and example insert statements while still allowing DuckDB expressions where needed. For large batches, prefer QuackDB.insert_rows/4, QuackDB.insert_columns/4, or QuackDB.Explorer.insert_dataframe/4.

Summary

row()

value()

Builds an INSERT INTO ... VALUES ... statement.

@type row() :: keyword(value()) | %{required(atom() | String.t()) => value()}

@type value() :: QuackDB.SQL.parameter() | {:expr, iodata()}

@spec insert_into(String.t() | atom(), [row()] | row()) :: iodata()

Builds an INSERT INTO ... VALUES ... statement.