---

SELECT
    field.key AS field_name,
    field.value AS field_value
FROM back_office.operation o
CROSS JOIN LATERAL
    jsonb_each_text(to_jsonb(o)) AS field
WHERE o.id = 81456425
  AND field.value IS NOT NULL
ORDER BY field.key;






SELECT
    d.id,
    d.number,
    d.date,
    d.accepted,
    d.canceled,
    d.rejected,
    d.ops_assignee_payment_id,
    p.id AS application_id,
    p.sharer_id,
    p.assignee_id
FROM back_office.ops_assignee_decision d
LEFT JOIN ourpension.ops_assignee_payment p
    ON p.id = d.ops_assignee_payment_id
WHERE d.id = 561;