Page History

MongoSQL queries are written using a subset of the SQL-92 standard. This document details Aqua Data Studio's MongoSQL syntax and functions. See the SQL Mapping page for how Aqua Data Studio's syntax maps to MongoDB Query syntax (http://docs.mongodb.org/manual/core/read-operations/#queries-in-mongodb).

...

• Query Syntax
  • SELECT
    • Subdocument and Array Fields
  • FROM
  • WHERE
  • GROUP BY
  • HAVING
  • ORDER BY
  • LIMIT and OFFSET
  • UNION | UNION ALL | INTERSECT | EXCEPT
• DML Syntax
  • INSERT
  • UPDATE
  • UPSERT
  • DELETE
• DDL Syntax
  • CREATE DATABASE
  • DROP DATABASE
  • CREATE COLLECTION
  • DROP COLLECTION
  • ALTER COLLECTION
    • DROP FIELD
    • RENAME FIELD
    • CAPPED SIZE
  • RENAME COLLECTION
  • CREATE INDEX
  • DROP INDEX
  • CREATE USER
  • ALTER USER
  • DROP USER
  • GRANT ROLE TO USER
  • REVOKE ROLE FROM USER
  • CREATE ROLE
  • DROP ROLE
  • GRANT PRIVILEGE TO ROLE
  • GRANT ROLE TO ROLE
  • REVOKE PRIVILEGE FROM ROLE
  • REVOKE ROLE FROM ROLE

...

• Supported Functions
  • Aggregate Functions
    • ADDTOSET
    • AVG
    • COUNT
    • FIRST
    • LAST
    • MAX
    • MIN
    • PUSH
    • SUM
  • Arithmetic and Mathematical Functions
    • / Division operator
    • - Minus operator
    • % or MOD Modulo operator
    • + Addition operator
    • * Multiplication operator
  • Bit Functions
    • & Bitwise AND
    • | Bitwise OR
    • << Left shift
    • >> Right shift
  • Date and Timestamp Support
  • Database References
  • Object IDs
  • Regular Expressions
  • BSON Data Types
  • Configuration Functions
  • Utility Statements
  • JavaScript Functions
  • • EVAL
    • EVAL_ARRAY
  • Miscellaneous Functions

Query Syntax

The MongoSQL Query Syntax is designed to allow the use of SQL-like statements to query the structured data documents of MongoDB. View the SQL Mapping reference to see how the MongoSQL syntax and commands map to MongoDB's commands.

...

SELECT city AS htowns
   FROM zips
   WHERE city LIKE 'H%' 

Subdocument and Array Fields

Querying subdocument and array data is supported automatically. Consider the following:

...