Запрос с БД сайта

SELECT
    loan.id AS "loan_id",
    loan.archiid,
    loan.createdat,
    CASE
        WHEN loan.partnerid IS NOT NULL
        THEN loan.partnerid
        ELSE NULL
    END AS "id партнера по маркетингу",
    loan.utm::jsonb->>'utm_source'::text AS utm_source,
    --ради этого преобразования и пришлось писать этот SQL-запрос
    loan.utm::jsonb->>'utm_campaign'::text AS utm_campaign,
    loan.utm::jsonb->>'utm_term'::text AS utm_term,
    loan.utm::jsonb->>'utm_content'::text AS utm_content,
    loan_meta.issuingsource AS "id места получения"
FROM
    loan
LEFT JOIN loan_meta ON
    loan.id = loan_meta.loan_id
WHERE
    loan.archiid IS NOT NULL
    AND loan.deletedat IS NULL
    --and loan.archiid = 984216
    AND loan.createdat >= CURRENT_DATE - INTERVAL '7 days'
    AND loan.createdat < CURRENT_DATE
ORDER BY
    archiid