Group several SQLite files under one connection

[datlechin]

Problem

Each SQLite file is its own connection. A project holding several, which is normal when a schema is split by concern, fills the connection list with entries that belong together and cannot be queried across without an ATTACH typed by hand.

Proposed solution

• Several file paths on one SQLite connection, each attached under a name.
• Each attached database as its own node in the sidebar, with its tables under it.
• Cross-database queries work, since ATTACH is what makes them work.
• The same for DuckDB and libSQL, which have the same ATTACH.

Alternatives considered

One connection per file, and ATTACH typed into every query tab.

Related database type

SQLite