Drizzle ORMでorderByを動的に指定する

#Drizzle #TypeScript #SQLite

sql.raw を使う。

import { sql } from "drizzle-orm";
import { db } from "./db";
import { users } from "./schema";

const columnName = "createdAt";
const order = "desc";

const users = await db
  .select()
  .from(users)
  .orderBy(sql.raw(`${columnName} ${order}`));