Query editor
SELECT'boba' AS chain,concat('0x', to_hex(address)) AS address,coalesce(namespace, name, '') AS entity,concat_ws(':', coalesce(name, ''), coalesce(detection_source, '')) AS extra,'decoded_contract' AS role,'evm_contract' AS address_kind,true AS source_eligibleFROM boba.contractsWHERE address IS NOT NULL