1
2
3
4
5
6
7
8
9
10
11
12
import { zip } from "https://esm.town/v/pomdtr/sql";
import { createClient } from "https://jsr.io/@pomdtr/sqlite-explorer/0.0.6/client.ts";
const client = createClient({
url: "https://sqlite-example.pomdtr.me",
});
export default async function() {
const res = await client.execute("SELECT name FROM artists");
const rows = zip(res);
return Response.json(rows);
}