Couchbase is rolling out a new SQL query language that gives developers the ability to combine JSON data modeling with declarative SQL queries for NoSQL data.
The NoSQL database platform provider announced a beta of the N1QL language as part of Couchbase Server 4.0. According to Couchbase CEO Bob Wiederhold, N1QL is a NoSQL query language based on SQL used to query JSON-based document databases. N1QL also enables developers to integrate Couchbase data with third-party business intelligence and reporting tools.
“The N1QL query language allows us to expand the use cases we can support for Web, mobile and IoT applications,” said Couchbase CEO Bob Wiederhold. “N1QL makes it easier to access and manipulate the data stored in Couchbase with ad hoc and complex queries for developers to build those kinds of capabilities into their applications.”
Wiederhold explained that the NoSQL movement was designed to get away from relational databases, not from SQL. N1QL is intended to act as a SQL-based language for the NoSQL space much the same as players in the Hadoop space leverage SQL queries, he said.
Couchbase also developed the language in collaboration with the University of California, San Diego’s (UCSD) computer science department, aligning the language to UCSD’s SQL++ query language specification. SQL++ is a formally defined SQL backward-compatible declarative language for semi-structured data.
N1QL is the first query language aligned with the academic standard, according to Wiederholder.
N1QL’s developer features and road map
Aside from the query language’s JSON data capabilities, Wiederholder drew attention to N1QL features developers should pay attention to as they build applications within frameworks.