Feature request: Support globbing to read from multiple similiar sqlite databases

[onnimonni]

Hey,

I have numerous sqlite files 1.db, 2.db, ... with exact same tables and I'm looking for a way to combine them with duckdb.

I would want to read all of them with a glob but I don't think this is currently possible:

INSTALL sqlite_scanner;
LOAD sqlite_scanner;
SELECT COUNT(*) FROM sqlite_scan('1.db', 'locations');
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│    123456    │
└──────────────┘
SELECT COUNT(*) FROM sqlite_scan('2.db', 'locations');
┌──────────────┐
│ count_star() │
│    int64     │
├──────────────┤
│    101589    │
└──────────────┘
SELECT COUNT(*) FROM sqlite_scan('*.db', 'locations');
Invalid Error:
Unable to open database "*.db": unable to open database file