UNNEST

1
SELECT UNNEST([1, 2, 3, 4, 5]) AS number;

1
SELECT
2
  product_name,
3
  UNNEST(tags) AS tag
4
FROM products;

1
SELECT
2
  UNNEST(['a', 'b', 'c']) AS letter,
3
  UNNEST([1, 2, 3]) AS number;

1
SELECT
2
  tag,
3
  COUNT(*) AS usage_count
4
FROM products, UNNEST(tags) AS t(tag)
5
GROUP BY tag
6
ORDER BY usage_count DESC;