database

// SQL (SELECT / DML / DDL) — auto-resolves the user's single fullstack app
await naive.database.query("select now()");
await naive.database.query("create table notes (id serial primary key, body text)");

// Target a specific app when the user owns several
await naive.database.query("select 1", { appId: "app-uuid" });

// Tables + row counts
const { tables } = await naive.database.tables();

// PostgREST CRUD (service-role key; RLS bypassed)
const notes = naive.database.from("notes");
await notes.insert({ body: "hello" });
await notes.select("id,body", "order=id.desc&limit=5");
await notes.update({ body: "edited" }, "id=eq.1");
await notes.delete("id=eq.1");

// Schema change (DDL)
await naive.database.migrate("alter table notes add column created_at timestamptz default now()");