[SQL派]drizzle-orm(首选+SQL-like+多种风格+支持serverless)

prisma相当于hibernate, drizzle相当于mybatis

• @code https://github.com/drizzle-team/drizzle-orm (opens new window)

• @doc

  • https://orm.drizzle.team/ (opens new window)
  • https://drizzle.zhcndoc.com/ (opens new window)

目前支持的数据库有限, 仅PostgreSQL、MySQL、SQLite

await db
  .select()
  .from(countries)
  .leftJoin(cities, eq(cities.countryId, countries.id))
  .where(eq(countries.id, 10))

const result = await db.query.users.findMany({
  with: {
    posts: true
  },
});

import { sql } from 'drizzle-orm' 
const id = 69;
await db.execute(sql`select * from ${usersTable} where ${usersTable.id} = ${id}`)

---

参考 @ref