Json scalar — flexible data (spec)

model-এ spec Json? (টপিক ৫)। Prisma Client-এ value plain-object/array — লেখা যত সহজ:

await prisma.product.update({
  where: { id: 3 },
  data: {
    spec: { brand: "Logitech", warranty: "1y", ports: 2 },
  },
});

read:

const p = await prisma.product.findUnique({
  where: { id: 3 },
});
// p.spec.brand --- 'Logitech'

• Json → Postgres-এ jsonb
• filter path-ভিত্তিক: where: { spec: { path: ['brand'], equals: 'Logitech' } }
• জটিল jsonb query-তে $queryRaw বেইস — বড় flexibility