PaulieScanlon

import type { Users } from '../../pg-to-ts-db';

const response = await client.query<Users[]>('SELECT * FROM users');

PaulieScanlon

// ./pg-to-ts-db.d.ts 

// Table users
export interface Users {
  id: number;
  first_name: string;
  last_name: string;
  email: string;
  country: string | null;
}

PaulieScanlon

DATABASE_URL=postgresql://... npm run pg-to-ts-generate

PaulieScanlon

// package.json

"scripts": {
   ...
   "pg-to-ts-generate": "pg-to-ts generate -c $DATABASE_URL -o ./pg-to-ts-db.d.ts"
},

PaulieScanlon

npm install --save-dev pg-to-ts

PaulieScanlon

import type { Users } from '../../kysely-db';

const response = await client.query<Users[]>('SELECT * FROM users');

PaulieScanlon

// ./kysely-db.d.ts 

import type { ColumnType } from 'kysely';

export type Generated<T> = T extends ColumnType<infer S, infer I, infer U>
  ? ColumnType<S, I | undefined, U>
  : ColumnType<T, T | undefined, T>;

export interface Users {
  country: string | null;

PaulieScanlon

npm run kysely-generate

PaulieScanlon

// .env

DATABASE_URL="postgresql://..."

PaulieScanlon

// package.json

"scripts": {
   ...
   "kysely-generate": "kysely-codegen --out-file ./kysely-db.d.ts",
},