ADDRESS
20-byte Ethereum address stored as raw bytes. 0x-prefixed VARCHAR casts parse exact hex; VARCHAR output is hex for display. In Solidity ABI words, ADDRESS values are left-padded to 32 bytes.
Used by functions
Derived from generated function parameters and return types.
Input and output
- create_access_list
Builds an EIP-2930 access list for a transaction request. Each result row identifies an accessed account or storage slot and includes request status.
table function Live RPC RPC 3 overloads - create2_mine
Scans a bounded local CPU salt range for EIP-1014 CREATE2 addresses. It performs no network I/O, deployment, chain-state lookup, collision check, or vanity-address safety proof.
table function Offline 2 overloads - create2_predict
Computes the EIP-1014 CREATE2 address from the executing deployer, exact salt, and complete init-code hash. This is deterministic local arithmetic and does not query or mutate chain state.
scalar function Offline 2 overloads - get_logs
Reads logs matching emitter, inclusive block bounds, and topic filters. Live clients use eth_getLogs; retained execution clients read stored execution logs.
table function Live RPC RPC 12 overloads - read_contract_multicall
Executes a table of encoded contract reads through Multicall3 and returns one diagnostic row per input call. Results separately report batch execution and target-call success.
table function Live RPC RPC 1 overload
Accepted as input
- assume_code
Declares the exact EVM runtime bytecode supplied for one address in a PROGRAM's initial state.
scalar function Offline 1 overload - assume_native_balance
Declares the exact native balance, in Wei, supplied for one address in a PROGRAM's initial state.
scalar function Offline 1 overload - assume_no_code
Declares that one address has no EVM runtime bytecode in a PROGRAM's initial state.
scalar function Offline 1 overload - assume_nonce
Declares the exact account nonce supplied for one address in a PROGRAM's initial state.
scalar function Offline 1 overload - assume_storage
Declares the exact 32-byte value supplied for one contract storage slot in a PROGRAM's initial state.
scalar function Offline 1 overload - code_at
Reads an account's runtime bytecode from live RPC state, the exact state identified by a pinned CLIENT, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.
scalar function Live RPC RPC 4 overloads - evm_abi_word
Encodes an ADDRESS, BYTES32, BOOLEAN, or integer as one 32-byte Solidity ABI word. ADDRESS and unsigned integer values are left-padded with zeros. Signed integers are sign-extended in two's-complement form; BOOLEAN uses 0 or 1. BYTES32 values are copied unchanged.
scalar function Offline 1 overload - evm_decode_log_for
Returns a log diagnostic using the ABI registered locally for a chain, emitter, and block; use it when ABI selection depends on contract context.
scalar function Offline 1 overload - evm_decode_revert_for
Returns a revert diagnostic using the ABI registered locally for a chain, contract, and block; use it when ABI selection depends on contract context.
scalar function Offline 1 overload - evm_register_contract_abi
Stores contract ABI metadata in the current database for block-aware log and revert decoding.
scalar function Offline 4 overloads - execute_call
Builds one raw EVM call step for ordered, non-atomic PROGRAM execution.
scalar function Offline 2 overloads - execute_contract
Selects an ABI function, encodes its arguments, and builds one step for ordered, non-atomic PROGRAM execution.
scalar function Offline 2 overloads - hex
Formats a BLOB-backed EVM byte value as uppercase hexadecimal text without a 0x prefix. hex and to_hex are compatibility aliases with identical behavior.
scalar function Offline 1 overload - length
Returns the number of bytes in a BLOB or BLOB-backed EVM value such as ADDRESS, BYTES32, UINT256, or INT256.
scalar function Offline 1 overload - native_balance
Returns an address's native-token balance as exact Wei in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.
scalar function Live RPC RPC 3 overloads - nonce
Returns an address's transaction count in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.
scalar function Live RPC RPC 3 overloads - observation_fact
Declares a human-readable label for an address without scheduling a READ.
scalar function Offline 1 overload - raw_call
Executes an isolated EVM call and returns the raw response bytes. Without a CLIENT, it builds a reusable READ and does not execute the call.
scalar function Live RPC RPC 4 overloads - read_contract
Calls a contract function against live, pinned, or retained execution state and returns a typed SQL value. Without a CLIENT, it builds a reusable READ and does not execute the call.
scalar function Live RPC RPC 4 overloads - read_contract_at
Calls a contract function at an explicit block number and returns ABI-decoded SQL values.
scalar function Live RPC RPC 1 overload - storage_at
Returns one raw 32-byte storage word for a contract and BYTES32 slot in live, pinned, or retained execution state. Without a CLIENT, it builds a reusable READ and does not access state.
scalar function Live RPC RPC 3 overloads - to_hex
Formats a BLOB-backed EVM byte value as uppercase hexadecimal text without a 0x prefix. hex and to_hex are compatibility aliases with identical behavior.
scalar function Offline 1 overload - try_native_balance
Returns an address's native-token balance as exact Wei at an explicit block, as native_balance does. A balance read cannot revert, so a failed read raises here too.
scalar function Offline 1 overload - try_read_contract_at
Calls a contract function at an explicit block number like read_contract_at; a revert, an address without code or an undecodable return gives NULL instead of an error. A transport, rate-limit or archive failure raises.
scalar function Live RPC RPC 1 overload
Returned as output
- get_block
Fetches a block by decimal height, supported block tag, or block hash. The block defaults to latest and include_transactions defaults to false.
table function Live RPC RPC 5 overloads - get_transaction
Fetches a transaction by hash, then makes a separate receipt request for receipt metadata.
table function Live RPC RPC 2 overloads - get_transaction_logs
Returns logs from a transaction receipt, optionally filtered by emitter or indexed topics. Supply an event signature or JSON ABI to append typed decoded fields.
table function Live RPC RPC 6 overloads