Simple relational query in sqlite

import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';
import { relations } from 'drizzle-orm';
 
export const users = sqliteTable('users', {
    id: integer('id').primaryKey(),
    name: text('name').notNull(),
});
 
export const usersRelations = relations(users, ({ many }) => ({
    posts: many(posts)
}));
 
export const posts = sqliteTable('posts', {
    id: integer('id').primaryKey(),
    content: text('content').notNull(),
    authorId: integer('author_id').notNull(),
});
 
export const postsRelations = relations(posts, ({ one }) => ({
    author: one(users, { fields: [posts.authorId], references: [users.id] }),
}));

posts 3 columns 0 indexes 0 fks
users 2 columns 0 indexes 0 fks

[✓] Your SQL migration file ➜ drizzle/0000_silly_spitfire.sql 🚀