I've done some research and everywhere I look it sounds like nosql dbs, including elastic search use application side joins. For ES I understand the nested/parent-child options and have both implemented in my existing stack. But these are limited in functionality to a traditional join.
I'm wondering if there is a good solution to handling joins in a generic sense. For example, I have two document types with no nested/parent-child relationship set up in ES. But they do have ID's that can be used to join them. Is there a plugin/workflow/solution to do this other than a custom application side join?
I understand this isn't something ES is intended to handle and "this is what a relation DB is for".
I'm wondering is there is another pattern/plugin/option to do arbitrary document joins from ES?