Use case

Join CSV files with DuckDB SQL locally.

Bendit is useful when two exports belong together but live as separate CSV files: orders and customers, stock and products, invoices and payments.

Typical cases

• Need to match files from different systems
• Excel VLOOKUP becomes fragile
• Want a repeatable join query instead of manual copy/paste

Example SQL

select
  o.order_id,
  c.customer_name,
  o.order_date,
  o.amount
from orders o
left join customers c on c.customer_id = o.customer_id
where o.amount > 0;

How Bendit helps

1. Import the file directly into the local workbench.
2. Inspect columns, types and preview rows.
3. Transform with DuckDB SQL.
4. Export a clean CSV or Parquet result.