© 2026 Hedgehog Software, LLC
core queries
extras
const fineTunedModelsTotalThisMonthQuery = db .select({ count: count() }) .from(fineTunedModels) .where( and( eq(fineTunedModels.userId, userId), sql`${fineTunedModels.createdAt} >= date_trunc('month', now()) AND ${fineTunedModels.createdAt} < date_trunc('month', now()) + interval '1 month')`, ), ); const fineTunedModelsTotalQuery = db .select({ fineTunedModelsTotal: count() }) .from(fineTunedModels) .where(eq(fineTunedModels.userId, userId)); const dbUser = await db.query.users.findFirst({ with: { fineTunedModels: { extras: { totalThisMonth: fineTunedModelsTotalThisMonthQuery, total: fineTunedModelsTotalQuery, } }, }, where: (user, { eq }) => { return eq(user.id, userId); }, });