I'm having a blast with using PostgreSQL to hold unstructured data in JSON-B and then creating views off of that that "feel" like more conventional SQL.

If performance becomes an issue, just turn it into an MV... and then consider some indexing on the JSON itself.