custom SQL query page for Observable Framework + DuckDB

query.md

Custom Queries

const db = await DuckDBClient.of({
  table_one: FileAttachment("data/table_ond.parquet"),
  table_two: FileAttachment("data/table_two.parquet"),
});

const example = `select 1 as one
`;
const sqlInput = html`<textarea rows="12" style="width: 100%;">
${example}</textarea
>`;
const sql = Generators.input(sqlInput);

const tableOneSchema = db.query(`describe table_one`);
const tableTwoSchema = db.query(`describe table_two`);
const columns = ["column_name", "column_type"];

const response = db.query(sql);

${sqlInput}

Results

${response ? response.length : 0} rows ${Inputs.table(response)}

Table 1 Schema

${Inputs.table(tableOneSchema, { columns })}

Table 2 Schema

${Inputs.table(tableTwoSchema, { columns })}