Query editor
SELECT'boba' AS chain,concat('0x', to_hex(address)) AS address,coalesce(concat('0x', to_hex("from")), '') AS entity,coalesce(cast(max(block_number) AS varchar), '') AS extra,'created_contract' AS role,'evm_contract' AS address_kind,true AS source_eligibleFROM boba.creation_tracesWHERE address IS NOT NULLGROUP BY 1, 2, 3