Can we introduce a safe inArray method that won't throw if the array length === 0?

[juanvilladev]

In a query like the one below, if the templateEntryGroups array is empty, the whole query throws:

    const templateEntries = await tx
        .select()
        .from(transactionTemplateEntries)
        .where(
          inArray(
            transactionTemplateEntries.transactionTemplateGroupId,
            templateEntryGroups.map((group) => group.id),
          ),
        );

I understand in SQL, executing an 'in' query with an empty parenthesis throws so the implementation makes sense.

I propose we implement a safeInArray that won't throw similar to below:

      const safeInArray = (col: PgColumn, array: unknown[]) => {
        if (array.length === 0) return eq(sql`1`, sql`0`); // where 1 = 0, thus no rows are returned.
        return inArray(col, array);
      };

      const templateEntries = await tx
        .select()
        .from(transactionTemplateEntries)
        .where(
          safeInArray(
            transactionTemplateEntries.transactionTemplateGroupId,
            templateEntryGroups.map((group) => group.id),
          ),
        );