Aim was to prototype a db remote for om.next including business logic and navigation without introducing a ORM library. That is to say, can I hook up a pull api which provides fairly broad access to a database?
I had an query strategy for how this might not be hideously inefficient. A naive depth first traversal would be simpler but generate a frightening number of queries (in series). Instead I do one query per join and then package up the results.
Inner joins and derived logic are declared in a spec. That allows me to include additional fields needed for joins and connect up the data afterwards. Fun bit there is that the logic declares what data it needs like defui. I imagine logic could be optionally pushed into the db.