PaulieScanlon

SELECT name, country, email FROM users 

PaulieScanlon

CREATE TABLE analytics (
  id            SERIAL PRIMARY KEY,          
  date          TIMESTAMP WITH TIME ZONE NOT NULL,
  slug          VARCHAR NOT NULL,
  referrer      VARCHAR,
  flag          VARCHAR,
  country       VARCHAR,
  city          VARCHAR,
  latitude      DECIMAL,
  longitude     DECIMAL

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