Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE certificate (
  criterias text[]
);

INSERT INTO certificate VALUES
(ARRAY['{"url":"https://criteria.com", "description":"My Criteria"}', '{"url":"https://criteria2.com", "description":"Other Criteria"}'])
RETURNING *;

CREATE TABLE

criterias

{"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"}

INSERT 0 1

-- show
SELECT criterias
FROM certificate;

SELECT criterias::text
FROM certificate;

SELECT criterias::text::jsonb[]
FROM certificate;

criterias

{"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"}

SELECT 1

criterias

{"{"url":"https://criteria.com", "description":"My Criteria"}","{"url":"https://criteria2.com", "description":"Other Criteria"}"}

SELECT 1

criterias

{"{"url": "https://criteria.com", "description": "My Criteria"}","{"url": "https://criteria2.com", "description": "Other Criteria"}"}

SELECT 1

-- ALTER TABLE                 
ALTER TABLE certificate
ALTER COLUMN criterias TYPE jsonb[] USING criterias::text::jsonb[]

ALTER TABLE

TABLE certificate;

criterias

{"{"url": "https://criteria.com", "description": "My Criteria"}","{"url": "https://criteria2.com", "description": "Other Criteria"}"}

SELECT 1