HTSQL Reference

This document describes the HTSQL language. We start with describing the syntax of HTSQL, then we discuss the HTSQL data model and query semantics and conclude with a reference of HTSQL data types, functions and operators.

• HTSQL Grammar
  • Encoding
  • Lexical Structure
  • Syntax Structure
• Data Model
  • Model and Instances
  • Classes and Links
  • Records and Relations
  • Correspondence to the Relational Model
• Data Flows
  • Scalar Expressions
  • Navigation
  • Filtering
  • Aggregates
  • Projection
• Naming Scopes
  • Root Scope
  • Class Scope
  • Projection Scope
  • Modifying Scope
  • References
• Data Types
  • Regular and Special Types
  • Literal Expressions
  • Type Conversion
  • Boolean Type
  • Numeric Types
  • String Type
  • Enum Type
  • Date/Time Types
• Functions and Operators
  • Logical Functions and Operators
  • Numeric Functions
  • String Functions
  • Date/Time Functions
  • Aggregate Functions
  • Flow Operations
  • Scope Operations
  • Decorators
  • Formatters