I had this issue at a previous job where we would query an API (AWS actually) and store the entire response payload. As we started out we would query into the J

I had this issue at a previous job where we would query an API (AWS actually) and store the entire response payload. As we started out we would query into the JSONB fields using the JSON operators, however at some point we started to run into performance issues and ended up "lifting" the data we cared about to columns on the same record that stored the JSON.