Grabbing a particular value from a json type in sql

Question

I have these varies entries in a column that look like this

[{'bus': '008', 'device': '002', 'bDeviceClass': '0 (Defined at Interface level)',  'iSerial': '3 30J155001549',... }]

I want to grab the iSerial value 30J155001549 but I am not sure exactly how to do this in sql. Any recommendations are greatly appreciated.