As in return the relation behind the join or return the results of that as a json object?

The latter is easy with SQLites JSON support.