Does anyone know why Prisma doesn't allow to save an array of arrays as JSON (PostgreSQL)?

Hey Jawad 👋 Can you tell me more about your schema and how you're trying to save arrays of arrays? I'm able to save arrays of arrays locally.

@andrewicarlson Sure, this is the code:

menus.forEach((menu) => {
      const menuTreeOrder = (menu.menuTreeOrder ?? []) as Prisma.JsonArray;

      menuTreeOrder.push([menuCategory.id, []]);

      queries.push(
        dataSources.db.prisma.menu.update({
          where: { id: menu.id },
          data: {
            menuTreeOrder,
          },
        })
      );
    });

    if (queries.length) {
      await dataSources.db.prisma.$transaction(queries);
    }

Thanks for the context, @Jawad Sefiani. Have you tried removing the

[]

from

Json

in your schema? For example:

/// schema.prisma
menuTreeOrder  Json

const data = await prisma.x.create({
        data: {
            data: [
                "array",
                "of",
                "strings",
                [
                    "and",
                    "other",
                    "strings"
                ]
            ]
        }
    });

That didn't help either, im getting the same error:

"on prisma.updateOneMenu. Provided List<List<UUID | List<>>>, expected MenuUpdatemenuTreeOrderInput or Json:",
            "type MenuUpdatemenuTreeOrderInput {",
            "  set?: List<Json>",
            "  push?: Json | List<Json>",
            "}",
            "type MenuUpdatemenuTreeOrderInput {",
            "  set?: List<Json>",
            "  push?: Json | List<Json>",
            "}",

Sorry to hear that. Are you getting that same error after regenerating the Prisma client? When defining

Json[]

in the Schema it's expecting an array of JSON (as you found). If you migrate (or regenerate your prisma client) after removing

[]

and just setting ``menuTreeOrder _Json`_` I expect that to work. You may also consider removing

as Prisma.JsonArray;

as that declaration may not be casting as you desire. See https://github.com/sindresorhus/type-fest/blob/main/source/basic.d.ts for more details

It worked! Thank you!