tx_hash,

block_id,

signer_id,

node,

node_data,

typeof(node_data:graph),

try_parse_json(node_data) as node_data_parsed,

node_data:graph as json_data,

parse_json(node_data) :"like" as json_data_parse,

node_data:graph:key as keys,

try_parse_json(node_data:graph) :key as keys_parsed,

parse_json(parse_json(parse_json(node_data) :"like") :"key") :"blockHeight" as og_post_id,

parse_json(json_data) :key:blockHeight as test1

near.social.fact_decoded_actions

node = 'index'

-- and array_contains('like' :: variant, object_keys(node_data))

and node_data::string ilike '%ciocan%'

50