SQL Statements and Expressions API

This section presents the API reference for the SQL Expression Language. For a full introduction to its usage, see SQL Expression Language Tutorial.

• Column Elements and Expressions
  • Column Element Foundational Constructors
  • Column Element Modifier Constructors
  • Column Element Class Documentation
• Operator Reference
  • Comparison Operators
  • IN Comparisons
    • IN against a list of values
    • Empty IN Expressions
    • NOT IN
    • Tuple IN Expressions
    • Subquery IN
  • Identity Comparisons
  • String Comparisons
  • String Containment
  • String matching
  • String Alteration
  • Arithmetic Operators
  • Using Conjunctions and Negations
  • Conjunction Operators
  • Operator Customization
• Selectables, Tables, FROM objects
  • Selectable Foundational Constructors
  • Selectable Modifier Constructors
  • Selectable Class Documentation
  • Label Style Constants
• Insert, Updates, Deletes
  • DML Foundational Constructors
  • DML Class Documentation Constructors
• SQL and Generic Functions
• Custom SQL Constructs and Compilation Extension
  • Synopsis
  • Dialect-specific compilation rules
  • Compiling sub-elements of a custom expression construct
    • Cross Compiling between SQL and DDL compilers
  • Changing the default compilation of existing constructs
  • Changing Compilation of Types
  • Subclassing Guidelines
  • Further Examples
    • “UTC timestamp” function
    • “GREATEST” function
    • “false” expression
• Expression Serializer Extension
• Visitor and Traversal Utilities