SQL Statements and Expressions API

This section presents the API reference for the SQL Expression Language. For an introduction, start with Working with Data in the SQLAlchemy Unified Tutorial.

• Column Elements and Expressions
  • Column Element Foundational Constructors
  • Column Element Modifier Constructors
    • nullsfirst()
    • nullslast()
  • Column Element Class Documentation
    • ColumnExpressionArgument
  • Column Element Typing Utilities
• 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
  • Bitwise Operators
  • Using Conjunctions and Negations
  • Conjunction Operators
  • Parentheses and Grouping
• SELECT and Related Constructs
  • 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
  • Function API
  • Selected “Known” Functions
• Custom SQL Constructs and Compilation Extension
• Expression Serializer Extension
• SQL Expression Language Foundational Constructs
• Visitor and Traversal Utilities