Remove Duplicates from Array

what’s the easiest way to remove duplicates from an array?

"userids": [
      "abc123",
      "abc123"
    ]

@ismaen:

FROM
  item
IN
  userids
SELECT DISTINCT
  item