SQL Reference

The FDB relational subproject provides a SQL API for interacting with Record Layer databases. This SQL API is currently under active development and is expected to change frequently. This reference is currently also a work in progress to be updated as the SQL engine develops.

SQL

• SQL Data Types
  • Primitive Types
  • Struct Types
  • Array types
  • NULL Semantics
• SQL Commands
  • DQL
  • DDL
  • DML
• Functions
  • Aggregate Functions
  • Scalar Functions

Data Model

• Databases, Schemas, Schema Templates
  • Schemas
  • Databases
  • Schema Templates
  • Bridging a pre-existing Record Layer setup
• Tables
  • Single row tables
• Indexes
  • Defining indexes
  • Indexes on nested fields
  • Index rules
  • Implementation details

Miscellaneous

• Direct Access API
  • Scan
  • Get
  • Insert
  • Delete
• Understanding How Bitmaps Identify Distinct Values