HTQL Developer Guide

Everything a developer sends to HTQLDB is one HTQL statement. Each entry gives its syntax, its parameters, what it returns and does, examples, who may run it, and how it fails.

  • Language reference

    Fundamentals, Expressions, Data queries, Data manipulation, Schema management, Loops, Analytics, Graph operations, Key-value store

  • Function reference

    Mathematics, Statistics, Logical, Text, Date & time, Arrays, Data transformation, Database, Finance, Accounting, Forecasting, Planning & simulation, Risk & fraud, Commercial operations

  • Best practices

    GET, FOR or LOOKUP

  • FLOW reference

    FLOW definition and lifecycle, Variables and conditional execution, Execution steps and transitions, Triggers and events, Waiting and timeouts, Human verification, External integrations, AI invocation, Transaction commitment

  • Finance protocol

    Contracts and terms, Assets and positions, Minting and burning, Transfers and settlement, Escrow, Notarisation and signatures

  • AOS language reference

    Persona and Guild, DNA and capabilities, Semantic graph queries, Context composition, What-if analysis, Evidence and historical queries, AI execution, Governance

  • Security & governance

    Authentication, Access control, Permissions and clearance, Secrets, Consent and history access, Tenant isolation

  • Integration reference

    HTTP calls from a FLOW, Channels, Broadcasts, Notifications, email and SMS