> Can you give an example of something that you realistically would want to do in SQL that you can't with a JSON query? Can you define joins in terms of each o

> Can you give an example of something that you realistically would want to do in SQL that you can't with a JSON query? Can you define joins in terms of each other? Otherwise, any join that isn't left outer join ($lookup) can't be represented in an aggregate query AFAIK.