SELECT
t.*,
tmp.j,
tmp.j->>'navHandleIndex' nav,
decode_url_part(tmp.j->>'keyword') keyword
FROM "test_regex_url" t

LEFT JOIN (
    SELECT
    id,
    json_object(ARRAY_AGG(inner_tmp.j)) j
    FROM (
        SELECT
        id,
        (regexp_matches(value, '([a-zA-Z]+)\=([^&]+)', 'g')) j
        FROM "test_regex_url"
    ) inner_tmp
    GROUP BY id
) tmp
on t.id=tmp.id