NoSQL provides flexible schema. That means, each data set is self-describing, changing from tuple to tuple. Data can be flat or hierarchical. Using JSON is the most popular way to represent flexible and hierarchical schema for operational applications.
These new SQL engines are making SQL richer and relevant. N1QL is one of the premier SQL systems to aid operational applications to exploit JSON data model.
Let's look at examples:
JSON-in and JSON-out. Whether you project simple constant, key-value pairs, aggregates or any combination, the result set is a JSON document.
- It's SQL!