DuckDB's `FROM` statement accepts glob patterns

duckdb-glob-pattern.sql

/*
    DuckDB's `FROM` statement accepts glob patterns

    DuckDB version: 0.10.2

    Bill Wallis, 2024-05-10
*/


select version();


/*
    You'll need to create the folders manually first:

        `data/`
        `data/sub/`
        `data/sub/subsub/

    See the following for more information:

    - https://github.com/duckdb/duckdb/discussions/10665
*/
copy (select 1 as a, 2 as b, 3 as c) to 'data/one.csv';
copy (select 4 as a, 5 as b, 6 as c) to 'data/two.csv';
copy (select 7 as a, 8 as b, 9 as c) to 'data/sub/three.csv';
copy (select 0 as a, 0 as b, 0 as c) to 'data/sub/subsub/four.csv';


/* Just file headers */
from 'data/**/*.csv';


/* File headers with filenames */
from read_csv('data/**/*.csv', filename=true);

This is part of the following LinkedIn post:

https://www.linkedin.com/posts/bill-wallis_sql-duckdb-activity-7194788778744442880-Uw0S