It’s entirely possible to sort and filter inside JSON data in most SQL dialects. You can even add indexes.