We have a new requirement that clearly aims to the use of a NoSql database.
We have to process json files in a shared directory. This files will contain the detail of an item of the pharma industry. It can have thousands of different attributes and the structure can vary a lot, depending of the category.
If we store these files as json documents in a NoSql database.... how can we expose this data in a relational way (we're using Apex as front end) so other systems can read this data without the need of parsing and saving it?