SQL/Relational Model (experimental)

NavDB provides an in-memory relational model with a subset of SQL.

 

Limitations

As the SQL/relational model is still very new it is considered experimental and is not intended for any serious use beyond querying the system tables.

  • Data types: only the BOOLEAN, INTEGER, NUMERIC and VARCHAR data types are supported.

  • Objects: only tables and sequences are supported.

  • Queries: only the most basic SELECT statements are supported (no joins or subqueries).