Feature Request: Drag and drop local files to insert file path into cell

[hslim8888]

Feature Request

When working with local files in the DuckDB UI, it would be very convenient to drag and drop a file from Finder (or other file manager) into a
cell and have the file path automatically inserted at the cursor position.

Use Case

A common workflow is querying local files:

SELECT * FROM read_csv('/Users/me/data/some_long_path/sales_2026.csv');

Currently, the file path must be typed or copied manually. Being able to drag a file directly into the cell and have its path inserted would significantly speed up this workflow.

Expected Behavior

1. Drag a local file from Finder into a cell
2. The appropriate query is auto-generated based on the file extension:

Extension	Generated query
.csv	SELECT * FROM read_csv('/path/to/file.csv');
.parquet	SELECT * FROM read_parquet('/path/to/file.parquet');
.json	SELECT * FROM read_json('/path/to/file.json');
.xlsx	SELECT * FROM st_read('/path/to/file.xlsx');
other / unknown	SELECT * FROM '/path/to/file.ext';

DuckDB can auto-detect file types for simple SELECT * FROM 'path' syntax,
so for unknown extensions, inserting just the path as a string would be a safe fallback.

[jraymakers]

Thanks for the suggestion!