[xkcd-sucks]

>For example, can it...

Yes. There will be a subquery and jsonb indexes need to be thought out in order to make it fast