SQL Support

Standard SQL alongside JSON queries. Collections are tables.

SELECT name, age, department
FROM users
WHERE age >= 25 AND department = 'Engineering'
ORDER BY age DESC
LIMIT 10;

INSERT INTO users (name, age) VALUES ('Alice', 30);

UPDATE users SET age = 31 WHERE name = 'Alice';

DELETE FROM users WHERE status = 'inactive';

-- Aggregation
SELECT department, COUNT(*), AVG(salary)
FROM users
GROUP BY department;

-- Joins
SELECT u.name, o.total
FROM users u
JOIN orders o ON u._id = o.user_id;

-- Index management
CREATE INDEX idx_email ON users(email);
DROP INDEX idx_email ON users;

-- Database management
CREATE DATABASE myapp;
USE myapp;
SHOW DATABASES;