welcome
TODO
CREATE SCHEMA
SELECT FORM SCHEMA UDPATE SHIT GET ALL DATA WoRKING
sql garden is an omage to a simpler time, a time when we sowed our own schemas and grew our databases organically.
import { DuckDBClient } from "npm:@observablehq/duckdb";
import { Editor } from "./components/Editor.js";
const db = DuckDBClient.of({});
display(db)
// const conn = db.connect();
Query Explorer
display(await db.query(schema))
tables
audit;
const tables = await db.describeTables()
const audit = view(Inputs.button("audit"));
display(tables)
audit;
// run;
const count = await db.query(`SELECT * FROM foo ORDER BY added DESC`)
Inputs.table(count)