You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem? Please describe.
Other drivers (e.g. Postgres) have inherent support for SQL SCHEMA (and usually CATALOG). SQLite doesn't have CATALOG support, but by attaching a database, it effectively has SCHEMA support.
Issue #270 exposes the ability to switch schema per query. But we can't implement this functionality for SQLite until there's a means to attach databases.
Describe the solution you'd like
It should be possible to attach databases to a SQLite source, at a minimum, after the source has been added, and maybe when creating the soruce. An example implementation might be:
Should the path of the attached db be stored as an absolute filepath, or as relative to the main db file (whose filepath is already stored as an absolute path)?
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem? Please describe.
Other drivers (e.g. Postgres) have inherent support for SQL
SCHEMA
(and usuallyCATALOG
). SQLite doesn't haveCATALOG
support, but by attaching a database, it effectively hasSCHEMA
support.Issue #270 exposes the ability to switch schema per query. But we can't implement this functionality for SQLite until there's a means to attach databases.
Describe the solution you'd like
It should be possible to attach databases to a SQLite source, at a minimum, after the source has been added, and maybe when creating the soruce. An example implementation might be:
Note that the
sq src attach
form is only an example of a possible implementation. Maybesq config edit @sqlite
or such could work too.Describe alternatives you've considered
N/A
Additional context
sq src
(get source details), or maybesq src -j
?The text was updated successfully, but these errors were encountered: