Drizzle ORM에서 IN 절 사용

import { inArray } from 'drizzle-orm'

const authorIds = [1, 2, 3]

// SELECT * FROM authors WHERE id IN (1, 2, 3)
const authors = await db
  .select()
  .from(schema.authors)
  .where(inArray(schema.authors.id, authorIds))

// 빈 배열 처리
const result =
  authorIds.length > 0
    ? await db
        .select()
        .from(schema.authors)
        .where(inArray(schema.authors.id, authorIds))
    : []
#drizzle#orm#sql
#511