How normalized are you gonna make em? If you are okay to stick to something like postgres as your back end, then you are able to just shove the JSON directly into json or jsonb fields. Pleroma does this for AP events. Postgres has extensive support for manipulating and querying the JSON objects that you shove into it.

Just depends what you are going for, really