Open
Description
Enhancement
While these expressions share the same semantics, their current implementations and performances vary.
-- 0.096s
select count(*) from bluesky where get_json_string(data, 'commit.operation') = 'create';
-- 0.097s
select count(*) from bluesky where cast(data-> 'commit.operation' as varchar) = 'create';
-- 0.621s
select count(*) from bluesky where (data-> 'commit.operation') = 'create';