How to lint array input

[okaisti]

I'm trying out safeql for our prisma queries. now, i can't seem to get my custom "upsertMany" executeRaw call to be linted. This is a valid call, and works as intended, but safeql complains about:

Invalid Query: The type "Sql" has no corresponding PostgreSQL type.
Please add it manually using the "overrides.types" option:

code:

    await this.prisma.$executeRaw`
    INSERT INTO "Table" (
      id,
      order_number,
      parent_id,
      name,
    )
    VALUES ${Prisma.join(
      input.map(
        (item) =>
          Prisma.sql`(
            ${item.id}::UUID,
            ${item.order_number}::INTEGER,
            ${item.parent_id}::UUID,
            ${item.name}::TEXT,
          )`,
      ),
    )}
    ON CONFLICT (id) DO UPDATE SET
      order_number = EXCLUDED.order_number,
      parent_id = EXCLUDED.parent_id,
      name = EXCLUDED.name
    ;
    `;

eslint config:

...
'@ts-safeql/check-sql': [
      'error',
      {
        connections: [
          {
            migrationsDir: './prisma/migrations',
            targets: [{ tag: 'prisma.+($queryRaw|$executeRaw)', transform: '{type}[]' }],
          },
        ],
      },
    ],

[Newbie012]

SafeQL currently doesn't support sql fragments. Hopefully, when I have enough time, I'll add support for it. You can track down this issue here

[Newbie012]

In order to keep using SafeQL while not blocking you from using Prisma's SQL fragments, you can incrementally adopt SafeQL.