DQL

The Relational Layer supports a full query engine, complete with query planning and index selection. We generally recommend using the query planner whenever possible over using the Direct Access API as it is more powerful and more capable, and it is designed to make intelligent choices regarding query planning decisions like appropriate index selection.

The language is heavily inspired by SQL. However, the Relational Layer does make some important changes to SQL to accommodate the nature of its data model (particularly with regard to struct and array data types).

Syntax

• SELECT
  • Syntax
  • Parameters
  • Examples
• WITH
  • Syntax
  • Parameter
  • Example
• WHERE
  • Syntax
  • Parameter
  • Examples
• EXPLAIN
  • Syntax
  • Parameters
  • Returns
  • Examples

• Operators