By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 4 Duplicates: 0 Warnings: 0
| type | json_object('state', `state`, 'city', `city`,'zipcode',`zipcode`) |
|---|---|
| hot | {"city": "phx", "state": "az", "zipcode": 85281} |
| hot | {"city": "dal", "state": "tx", "zipcode": 12345} |
| cool | {"city": "sea", "state": "wa", "zipcode": 67890} |
| cool | {"city": "nyc", "state": "ny", "zipcode": 67856} |