Back to Drizzle Orm

0.19.0

changelogs/drizzle-orm/0.19.0.md

0.45.2591 B
Original Source
  • Implemented selecting and joining a subquery. Example usage:

    ts
    const sq = db
      .select({
        categoryId: courseCategoriesTable.id,
        category: courseCategoriesTable.name,
        total: sql`count(${courseCategoriesTable.id})`.as<number>(),
      })
      .from(courseCategoriesTable)
      .groupBy(courseCategoriesTable.id, courseCategoriesTable.name)
      .subquery('sq');
    

    After that, just use the subquery instead of a table as usual.

  • ❗ Replaced db.select(table).fields({ ... }) syntax with db.select({ ... }).from(table) to look more like its SQL counterpart.