PaulieScanlon

.select({
  id: users.user_id,
  first_name: users.first_name,
  last_name: users.last_name,
  email: users.email,
  role: users.role,
})
.from(users)
.where(eq(users.role, 'admin'))
.orderBy(users.last_name);

PaulieScanlon

import { pgTable, serial, varchar } from 'drizzle-orm/pg-core';

export const users = pgTable('users', {
  user_id: serial('user_id').primaryKey(),
  first_name: varchar('first_name', { length: 100 }),
  last_name: varchar('last_name', { length: 100 }),
  email: varchar('email', { length: 80 }).unique(),
  role: varchar('role', { length: 20 }),
});

PaulieScanlon

CREATE TABLE USERS (
  user_id     SERIAL PRIMARY KEY, 
  first_name  VARCHAR(100), 
  last_name   VARCHAR(100), 
  email       VARCHAR(80) UNIQUE, 
  role        VARCHAR(20)
);

PaulieScanlon

.select({
  city: analytics.city,
  country: analytics.country,
  flag: analytics.flag,
  count: sql`COUNT(${reactions.id})`.as('count'),
})
.from(analytics)
.innerJoin(reactions, eq(analytics.slug, reactions.slug))
.where(and(eq(reactions.reaction, 'happy'), gte(analytics.date, new Date(new Date().getTime() - 30 * 24 * 60 * 60 * 1000))))
.groupBy(analytics.city, analytics.country, analytics.flag)

PaulieScanlon

xata.db['users'].select(['name', 'country', 'email']).getMany();

PaulieScanlon

supabase.from('users').select('name, country, email');

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;
}