JSONQuery Pro : Run SQL on JSON Data

Output:



    
    
    
    

      User Guide — How to Use
      
1. Enter JSON Data

      
Paste any valid JSON array into the JSON box. Example:

      
[
  { "id": 1, "name": "John", "age": 25 },
  { "id": 2, "name": "Mary", "age": 30 }
]


      
2. Write SQL Query

      
Use SQL syntax. The JSON array is treated as table ?.


      Examples:
      
SELECT * FROM ?

      
SELECT name FROM ? WHERE age > 25


      
3. Working with Nested JSON

      

        JSONQuery Pro supports nested object queries using -> operator.
      


      Nested JSON Example:
      
[
  { "id": 1, "name": "John", "address": { "city": "Mumbai", "pincode": 400001 } }
]


      Query:
      
SELECT name, address->city FROM ? WHERE address->pincode = 400001


      
4. Array Inside JSON

      
{
  "name": "John",
  "skills": [
    { "type": "js", "level": 4 },
    { "type": "node", "level": 5 }
  ]
}


      Query:
      
SELECT user->name, skill->type
FROM ? AS user
JOIN user->skills AS skill
    


      
5. Track Usage (Analytics Enabled)

      
Every time you click Run Query, Google Analytics tracks:

      

      
6. Validate JSON

      
Ensure JSON is valid. If invalid, fix using:

      

      
7. Limitations