Best way to get all unique strings from string[] column

  const tagsSubquery = db
    .select({
      tag: sql<string>`UNNEST(${listings.tags})`.as('tag')
    })
    .from(listings)
    .where(eq(listings.marketplaceIntegrationId, marketplaceIntegrationId))
    .as('tags');
  const [{ tags }] = await db
    .select({
      tags: sql<SearchTagsResponse>`ARRAY_AGG(DISTINCT ${tagsSubquery.tag})`
    })
    .from(tagsSubquery)
    .where(
      and(
        // Not using ilike function here because it causes a type error https://github.com/drizzle-team/drizzle-orm/issues/2395
        sql`${tagsSubquery.tag} ilike ${`%${searchTerm}%`}`,
        excludedTags?.length ? notInArray(tagsSubquery.tag, excludedTags) : undefined
      )
    )
    .limit(10);