PostQuery

import { QueryClient, DataType, CreateTableMode } from "https://deno.land/x/postquery/mod.ts";

const client = new QueryClient(/* Connection URI or Connection Object */);
const users = client.table<{
  id: number,
  name: string,
}>("users");

await users.create({
  id: {
    type: DataType.Integer,
    primaryKey: true,
  },
  name: {
    type: DataType.VarChar,
    length: 20,
  }
}, CreateTableMode.DropIfExists);

await users.insert({
  id: 1,
  name: "User 1",
}, {
  id: 2,
  name: "User 2",
}, {
  id: 3,
  name: "User 3",
});

await users.where({
  id: 2
}).select("name"); // { name: "User 2" }

await users.where().limit(2).select(); // [ { id: 1, name: "User 1" }, { id: 2, name: "User 2" } ]

await users.where({ id: 1 }).delete();

await users.where({
  id: 1
}).select(); // []