DuckDB

Execute DuckDB SQL queries

DuckDB

AI-generated

Summary

Validates the required SQL Query field, then returns one item per incoming item with the query, a fixed Test mode result, an ISO timestamp, and that input item's index. It does not execute the SQL against DuckDB.

Inputs

  • SQL Query (required) — SQL text to include in each output item. Defaults to SELECT 1 as test; an empty or whitespace-only value causes an error.

Output shape

A list of items, one for each incoming item.

Each item contains query, result (Test mode), timestamp (ISO string), and inputIndex (zero-based). With no incoming items, the output list is empty. Validation or execution errors are wrapped as DuckDB execution failed.

Links

Discussion