Update nested array value with drizzle, (eq/et al functions)

[magicspon]

Hello,

I'm trying to updated a nested array value without having to replace the entire array.

Using drizzle I should be able to do something like:

  await payload.db.drizzle
    .update(payload.db.tables.event_drinks_twists)
    .set({
      active: false,
    })
    .where(eq(payload.db.tables.event_drinks_twists.id, '675d9df9f4fb0c85e2d05439'))

If i import { eq } from 'drizzle-orm' I get a bunch of ts errors and the code doesn't seem to work.

Argument of type 'import("/me/payload-durp/node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected]/node_modules/drizzle-orm/sql/sql").SQL<unknown>' is not assignable to parameter of type 'import("/me/payload-durp/node_modules/.pnpm/[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/drizzle-orm/sql/sql").SQL<unknown>'.
  Types have separate declarations of a private property 'shouldInlineParams'.

Any idea where I should be importing eq from? And/or is there a better way of doing this?

This is my field, I'm trying to update the active checkbox on the twists array

{
  name: 'drinks',
  type: 'array',
  fields: [
    {
      name: 'base',
      type: 'relationship',
      relationTo: ['base'],
      required: true,
    },
    {
      name: 'twists',
      type: 'array',
      fields: [
        {
          name: 'twists',
          type: 'relationship',
          relationTo: ['twist'],
          required: true,
        },
        { name: 'active', type: 'checkbox', defaultValue: true },
      ],
      required: true,
    },
  ],
},

[magicspon]

Maybe this pr is related #9953