Postgres 12

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();

version

PostgreSQL 12.17 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-20), 64-bit

SELECT 1

create table test (data hstore,h_store_column jsonb);

CREATE TABLE

insert into test(data) values (
'"entity" => "[{''id'': ''11954_179415600_2441_333_1'', ''vehicle'': {''trip'': {''tripId'': ''1182456'', ''routeId'': ''2441_333'', ''startDate'': ''20200822'', ''startTime'': ''22:14:00'', ''scheduleRelationship'': ''SCHEDULED''}, ''vehicle'': {''id'': ''11954_179415600_2441_333_1''}, ''position'': {''speed'': 0.0, ''bearing'': 297.0, ''latitude'': -33.876972, ''longitude'': 151.21237}, ''timestamp'': ''1598100524'', ''congestionLevel'': ''RUNNING_SMOOTHLY'', ''occupancyStatus'': ''MANY_SEATS_AVAILABLE''}}]"');

INSERT 0 1

Alter TABLE test 
   ALTER COLUMN h_store_column TYPE jsonb 
   USING replace(hstore_to_jsonb_loose(data)->>'entity','''','"')::jsonb;

ALTER TABLE

select * from test

data
h_store_column

"entity"=>"[{'id': '11954_179415600_2441_333_1', 'vehicle': {'trip': {'tripId': '1182456', 'routeId': '2441_333', 'startDate': '20200822', 'startTime': '22:14:00', 'scheduleRelationship': 'SCHEDULED'}, 'vehicle': {'id': '11954_179415600_2441_333_1'}, 'position': {'speed': 0.0, 'bearing': 297.0, 'latitude': -33.876972, 'longitude': 151.21237}, 'timestamp': '1598100524', 'congestionLevel': 'RUNNING_SMOOTHLY', 'occupancyStatus': 'MANY_SEATS_AVAILABLE'}}]"
[{"id": "11954_179415600_2441_333_1", "vehicle": {"trip": {"tripId": "1182456", "routeId": "2441_333", "startDate": "20200822", "startTime": "22:14:00", "scheduleRelationship": "SCHEDULED"}, "vehicle": {"id": "11954_179415600_2441_333_1"}, "position": {"speed": 0.0, "bearing": 297.0, "latitude": -33.876972, "longitude": 151.21237}, "timestamp": "1598100524", "congestionLevel": "RUNNING_SMOOTHLY", "occupancyStatus": "MANY_SEATS_AVAILABLE"}}]

SELECT 1