Navigate the data universe

import { db } from './db';

// Define your model
const users = db.table('users', {
  id: db.serial().primaryKey(),
  name: db.text(),
  email: db.text().unique(),
  createdAt: db.timestamp().defaultNow()
});

// Type-safe queries
const newUser = await db.insert(users)
  .values({
    name: 'John Doe',
    email: 'john@example.com'
  })
  .returning();

// Relations are simple
const posts = db.table('posts', {
  id: db.serial().primaryKey(),
  title: db.text(),
  content: db.text(),
  authorId: db.integer()
    .references(() => users.id)
});

// Enjoy type safety
const result = await db.select({
  author: users.name,
  title: posts.title
})
.from(posts)
.innerJoin(users, eq(posts.authorId, users.id))
.where(eq(users.id, 1));