$pg->db->query(
  'select array_agg(distinct state) from minion_jobs'
)->array;

$pg->db->query(
  'select array_agg(distinct state)::text[] from minion_jobs'
)->array;