[SQLITE experimental] Unable to open database

[carlopi]

As reported here: #1202 (comment)

reproducible also as

LOAD sqlite_scanner;
CALL sqlite_attach('https://raw.githubusercontent.com/duckdblabs/sqlite_scanner/main/data/db/count.db');
PRAGMA show_tables

Plus, but the extension short-name should be sqlite (there is confusion between repo name and extensions names)

[carlopi]

Update here:

This is connected to a missing functionality in the sqlite_parser extension, and there is a path to solve this via providing a virtual file system backed by DuckDB's own file system.

And on the extension name I was wrong, proper name is sqlite_scanner, and now aliases works as intended.

[carlopi]

Reproduction: https://shell.duckdb.org/#queries=v0,LOAD-sqlite~,CALL-sqlite_attach('https%3A%2F%2Fraw.githubusercontent.com%2Fduckdb%2Fsqlite_scanner%2Fmain%2Fdata%2Fdb%2Fcount.db')~