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

Editor

Result

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)