title: querying JSON data in azure blob storage
body: <p>We use azure blob storage for our project and store the JSON string in the blob container. For some purpose, we parse this JSON string to break it into rows and columns and then show in the Grid control on the UI. Grid control offers the features like filtering, grouping etc on the client side. However, when the data is huge such operations take time hence the UI becomes unresponsive. So, now we want to perform such operations on the server so that the grid loads with relevant data from the server faster and not all rows.</p>
  
  <p>For this we think we need to query the JSON data for filtering, grouping, paging etc but not sure if blob storage or any other cloud storage mechanism( DocumentDB ) provides such features. We have an option to go with PostgreSQL but we would like to stick to cloud based infrastructure primarily.</p>
  
  <p>Any ideas on how to query JSON data while being on AZURE and using the azure storage (not Azure SQL, but table storage, blob storage, etc less costly)</p>