Comparing Two SQL-Based Approaches For Querying JSON: SQL++ and SQL:2016

in IT & Engineering, White Paper Research / by /

In this whitepaper, Don Chamberlin (co-designer of the original SQL) compares SQL++ and SQL:2016 – two quite different SQL-based approaches to querying JSON data. SQL++ creates a new SQL-based language specifically for JSON data, while 2016 allows JSON documents to be stored in columns of tables. The paper introduces both languages, looks at example queries written in each, and analyzes their pros and cons. You’ll learn how SQL++ can enable you to:

• Use your existing SQL skills with a more flexible data format
• Shorten your queries by about 3x compared with SQL:2016
• Operate on JSON data without converting it to or from relational data