[BUG]:arrayJoin doesn't seem to work with string arrays

[nick-inkeep]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.39.0

What version of drizzle-kit are you using?

0.30.3

Other packages

No response

Describe the Bug

The following query arrayOverlaps where clause resulted in an unexpected ERR error: operator does not exist: text[] && record error

 .where(
      and(
        eq(table.organizationId, orgId),
        arrayOverlaps(table.messageIds, questionIds),
      ),
    );

This exact replacement does work:

  const formattedIds = questionIds.map(id => `'${id}'`).join(', ');

 .where(
      and(
        eq(table.organizationId, orgId),
        sql.raw(`table.message_ids && ARRAY[${formattedIds}]::text[]`),
      ),

Also tried using `sql`` variations and not seemed to work, had to use sql.raw() in the end.