BYTES
Dynamic-length raw byte array used for calldata, return data, revert data, and packed ABI payloads. 0x-prefixed VARCHAR casts parse exact hex bytes; VARCHAR/hex output is for inspection, not numeric math.
Used by functions
Derived from generated function parameters and return types.
Input and output
- bytes_concat_agg
Concatenates BYTES chunks in aggregate input order, preserving an aggregate ORDER BY clause when supplied.
scalar function Offline 1 overload - 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 - 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
Accepted as input
- assume_code
Declares exact EVM runtime bytecode used to evaluate a PROGRAM offline.
scalar function Offline 1 overload - call_decode
Decodes selector-free function return data into typed SQL columns defined by the function's ABI outputs.
table function Offline 1 overload - decode_function_data
Validates and decodes selector-prefixed function calldata into typed SQL columns defined by the function's ABI inputs.
table function Offline 1 overload - error_decode_json
Returns a status-rich JSON description of EVM revert bytes; supply an ABI to decode matching custom errors.
scalar function Offline 3 overloads - event_decode
Returns one EVM log as ABI-derived typed columns; use it when a constant event ABI can define the SQL schema at bind time.
table function Offline 2 overloads - 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_disassemble
Decodes bytecode with evmone advanced static analysis fixed to the Osaka revision. It exposes 27 instruction, PUSH, block, stack, gas, storage, and call-hint columns without executing the code.
table function Offline 1 overload - execute_call
Builds one raw EVM call step for sequential, non-atomic PROGRAM execution.
scalar function Offline 2 overloads - 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 - log_decode_json
Returns a status-rich JSON description of one EVM log; use it when unknown, ambiguous, and malformed logs must remain distinguishable.
scalar function Offline 2 overloads
Returned as output
- abi_encode_packed
Encodes scalar values with Solidity's packed ABI rules. The result has no selector, offsets, lengths, or 32-byte padding.
scalar function Offline 1 overload - code_at
Returns deployed bytecode for an address 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 2 overloads - compile
Compiles Solidity or Vyper source through the configured external service and normalizes one row per returned contract artifact. It performs network I/O and sends the supplied source to that service.
table function External Service 4 overloads - encode_function_args
Encodes function arguments with standard ABI encoding and omits the 4-byte function selector.
scalar function Offline 1 overload - encode_function_data
Encodes function arguments as contract calldata: the function's 4-byte selector followed by standard ABI argument bytes.
scalar function Offline 1 overload - evm_pack_uint_be
Packs a UINT256 value into an exact-width big-endian BYTES value for ABI-adjacent byte construction.
scalar function Offline 1 overload - get_block
Returns block metadata for a block number, tag, or hash. Set include_transactions to request expanded transaction objects in transactions_full; otherwise transactions contains hashes.
table function Live RPC RPC 5 overloads - get_logs
Returns EVM event logs matching the supplied emitter, block, and topic filters. Supply a human-readable event signature or JSON ABI to append typed decoded fields.
table function Live RPC RPC 12 overloads - get_transaction
Returns transaction fields and available receipt metadata for a transaction hash. The client must point to the chain where the transaction exists.
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 - 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