@postgresql-typed/pg v0.3.6

npm install --save @postgresql-typed/pg
npm install --save-dev @postgresql-typed/cli

# Generate types
npx pgt gen

import { Client, isReady } from "@postgresql-typed/pg";

import { Databases, DatabasesData } from "./__generated__/index.js";

const client = await new Client<Databases>(
	DatabasesData,
	process.env.DATABASE_URI
).testConnection();

if (!isReady(client)) {
	throw new Error("Client not ready");
}

const table = client.table("<your table path>");

const result = await table.select.execute("*");
if (!result.success) {
	throw new Error("Failed to select");
}

console.log(result.data.rows);