databases

1 row where name = "wtr"

descending

id ▼	datasette_id	name
13	Wireless Telegraphy Register 10	wtr

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE databases (
            id integer PRIMARY KEY,
            datasette_id integer,
            name text,
            -- TODO: source_hash, license_hash etc
            FOREIGN KEY (datasette_id) REFERENCES datasettes(id)
        );