UI

duckdb -ui
CALL start_ui();

CSV Import

SELECT * FROM read_csv('input.csv');

SELECT * FROM 'input.csv';

CREATE TABLE new_tbl AS
    SELECT * FROM read_csv('input.csv');

INSERT INTO tbl
    SELECT * FROM read_csv('input.csv');

COPY tbl FROM 'input.csv';

CSV Export

COPY tbl TO 'output.csv' (HEADER, DELIMITER ',');

Describe a table

DESCRIBE tbl;
SHOW tbl; -- equivalent to DESCRIBE tbl;