SELECT REGEXP_SUBSTR( TRY_BASE64_DECODE_STRING(TX_MESSAGE:txn:note), '.* ":(.*)', 1, 1, 'e', 1) as substr_note,
PARSE_JSON(SUBSTRING( substr_note, 0, LEN(substr_note) -1 )) as json_note,
json_note:escrowAddr as escrow_wallet
from algorand.transactions
WHERE
tx_group_id = 'zqzH8XZxoaVXWmkHBMQw7NeLtYL7+nMSdk9euNbF+dE='