It isn't easy (perhaps not even possible) to get the name of the fruit Bob grows in his farm using any of these tools and the following data:
{
"models": [{
"title": "fruits",
"fields": [
{"name": "Name", "key": "3746"},
{"name": "Colour", "key": "4867"}
],
"entities": [{
"_id": "372612",
"3746": "Orange",
"4867": "orange"
}]
}, {
"title": "farmers",
"fields": [
{"name": "Full name", "key": "8367"},
{"name": "Address", "key": "3947"},
{"name": "Fruits", "key": "5243"}
],
"entities": [{
"_id": "747463",
"8367": "Bob, the farmer",
"3947": "Farmland",
"5243": ["372612"]
}]
}]
}