SQL++ Language Guide

SQL++ is a superset of SQL designed for JSON documents. Standard SQL syntax works — the differences are where JSON structure requires new constructs.

All examples use travel-sample. Set query context to travel-sample.inventory in the Workbench to omit the bucket/scope prefix.

SELECT basics

-- All fields
SELECT * FROM `travel-sample`.inventory.airline LIMIT 5;

-- Specific fields
SELECT name, country, iata FROM `travel-sample`.inventory.airline
WHERE country = "United States"
ORDER BY name
LIMIT 10;