SELECT p.codigo, f.sumaPctPagado, b.id, b2.comentario
   FROM proyecto p
   LEFT JOIN (
   	SELECT sum(porc_hes) as sumaPctPagado, id_pry
   	FROM facturacion
   	GROUP BY id_pry
   ) f
   ON p.codigo = f.id_pry 
   LEFT JOIN (
   	SELECT max(id) as id, id_pry
   	FROM bitacora
   	GROUP BY id_pry
   ) b
   ON p.codigo = b.id_pry
   LEFT JOIN bitacora b2 
   ON b.id = b2.id

await prisma.proyecto.aggregate({
    _sum: {
      include: {
        facturacion: {
          porc_hes: true
        }
      }
    }
  });

model User {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt

  chats Chat[]
}

model Chat {
  id         Int      @id @default(autoincrement())
  createdAt  DateTime @default(now())
  updatedAt  DateTime @updatedAt

  private    Boolean? @default(false)

  users User[]
}

[1,2,3]

[1,2]

[1,2,3,4]

this.prisma.chat.findFirst({
        where: {
          users: {
            every: {
              OR: [{id: 1}, {id: 2}, {id: 3}]
            }
          }
        }
      })

[1,2]

chat.findMany

links         Link[]

Link[]

Embed[]

previewFeatures = ["selectRelationCount"]

db.set.create({
  data: {
    ...someData,
    tokens: {
      createMany: {  // <-- need upsert equiv here
        data: [...tokens]
      }
    }
  }
})

some

every

every

some

prisma.applicationFormConfig.findMany({
        where: { organizations: { every: { id: organization.id } } },
})// yield all forms from all organization
prisma.applicationFormConfig.findMany({
        where: { organizations: { some: { id: organization.id } } },
      }),// works as expected

prisma:query SELECT "public"."ApplicationFormConfig"."id", ... FROM "public"."ApplicationFormConfig" WHERE ("public"."ApplicationFormConfig"."id") 
NOT IN (SELECT "t0"."A" FROM "public"."_ApplicationFormConfigToOrganization" AS "t0" 
INNER JOIN "public"."Organization" AS "j0" ON ("j0"."id") = ("t0"."B") 
WHERE ((NOT "j0"."id" = $1) AND "t0"."A" IS NOT NULL)) OFFSET $2

WHERE ((NOT "j0"."id" = $1)

$1

organization.id

some

WHERE ("j0"."id" = $1

model ApplicationFormConfig {
  id            String         @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
...
  organizations Organization[]
}

model Organization {
  id                      String                  @id @default(dbgenerated("gen_random_uuid()")) @db.Uuid
...
  applicationFormConfigs  ApplicationFormConfig[]
...
}

npx prisma db seed --preview-feature

AND

px prisma migrate dev --name initial-migration --create-only

npx prisma db push

ON DELETE CASCADE

mysql

information_schema.triggers

ON DELETE

ON UPDATE

mysql