ECSql Syntax & Features

• Operators
  • Bitwise operator
  • Arithmetic operator
  • String operator
  • Boolean operator
• Built-in functions
  • Scalar SQLite built-in functions
  • ECSQL Built-In functions
    • ec_classname()
    • ec_classid())
    • regexp()
    • regexp_extract()
    • strToGuid()
    • guidToStr()
• JSON1 virtual classes
  • json_tree()
  • json_each()
• Polymorphic vs non-polymorphic query
• ECSQLOPTIONS or OPTIONS clause
• Window functions
• DATE, TIME & TIMESTAMP Literals
• NULL, NUMBER, STRING & BOOLEAN Literals
• CASE-WHEN-THEN-ELSE
• IIF (condition-expr, true-expr, false-expr)
• LIKE operator
• CAST operator
• LIMIT clause
• GROUP BY clause
• CTE (Common table expression)
• ECClass filter
• ORDER BY clause
• ECSQL Parameters
• Compound SELECT
• JOINs
  • INNER JOIN
  • OUTER JOIN
  • JOIN USING
• Instance query
• Pragmas
  • help
  • ecdb_ver
  • experimental_features_enabled
  • integrity_check (experimental)
• ECSQL Keywords
  • Escaping keywords
• Views
• IdSet Virtual Table