Skip to content

GlueSQL

Nested

GlueSQL

Introduction
Getting Started
Getting Started
SQL Syntax
SQL Syntax
- Introduction
- Statements
  Statements
  - Querying
    Querying
    
    WHERE
    
    JOIN
    
    LIMIT & OFFSET
    
    Aggregation
    
    Schemaless Data
  - Data definition
    Data definition
    
    CREATE TABLE
    
    DROP TABLE
    
    CREATE INDEX
    
    DROP INDEX
    
    ALTER TABLE
  - Data manipulation
    Data manipulation
    
    INSERT
    
    UPDATE
    
    DELETE
  - Transaction
  - Metadata
    Metadata
    
    SHOW TABLES
    
    Data Dictionary
- Data types
  Data types
  - BOOLEAN
  - Integer Types
  - FLOAT
  - TEXT
  - DECIMAL
  - DATE
  - TIMESTAMP
  - TIME
  - INTERVAL
  - LIST
  - MAP
  - BYTEA
  - INET
  - UUID
- Functions
  Functions
  - Text
    Text
    
    ASCII
    
    CHR
    
    CONCAT
    
    CONCAT_WS
    
    FIND_IDX
    
    INITCAP
    
    LEFT
    
    LOWER
    
    LPAD
    
    LTRIM
    
    MD5
    
    POSITION
    
    REPEAT
    
    REVERSE
    
    RIGHT
    
    RPAD
    
    RTRIM
    
    SUBSTR
    
    TRIM
    
    UPPER
  - Math
    Math
    
    ABS
    
    ACOS
    
    ASIN
    
    ATAN
    
    CEIL
    
    COS
    
    DEGREES
    
    DIV
    
    EXP
    
    FLOOR
    
    GCD
    
    LCM
    
    LN
    
    LOG
    
    LOG10
    
    LOG2
    
    MOD
    
    PI
    
    POWER
    
    RADIANS
    
    RAND
    
    ROUND
    
    SIGN
    
    SIN
    
    SQRT
    
    TAN
    
    TRUNC
  - Date & Time
    Date & Time
    
    ADD_MONTH
    
    EXTRACT
    
    FORMAT
    
    LAST_DAY
    
    NOW
    
    TO_DATE
    
    TO_TIME
    
    TO_TIMESTAMP
  - List & Map
    List & Map
    
    APPEND
    
    CONCAT
    
    DEDUP
    
    ENTRIES
    
    IS_EMPTY
    
    KEYS
    
    LENGTH
    
    PREPEND
    
    SKIP
    
    SLICE
    
    SORT
    
    SQL Function - "SPLICE"
    
    TAKE
    
    VALUES
  - Geometry
    Geometry
    
    CALC_DISTANCE
    
    GET_X
    
    GET_Y
    
    POINT
  - Others
    Others
    
    CAST
    
    COALESCE
    
    GENERATE_UUID
    
    GREATEST
    
    IFNULL
AST Builder
AST Builder
- Introduction
- Statements
  Statements
  - Querying
    Querying
    
    Fetching Data from Storage
    
    Using Preloaded Data
    
    Creating Derived Subqueries
    
    Data Aggregation
    
    Data Injection
    
    Data Joining
    
    Data Selection and Projection
    
    Data Sorting and Limiting
  - Data Manipulation
    Data Manipulation
    
    Inserting Data
    
    Updating Data
    
    Deleting Data
- Expressions
  Expressions
  - Conditional
  - Nested Nested
    On this page
    
    Todo
  - Operator Based
  - Pattern Matching
  - Value Checking
- Functions
  Functions
  - Text
    Text
    
    Case Conversion
    
    Character Conversion
    
    Padding
    
    Position and Indexing
    
    Text Manipulation
    
    Trimming
  - Math
    Math
    
    Basic Arithmetic
    
    Conversion
    
    Logarithmic and Exponential
    
    Rounding
    
    Special Mathematical
    
    Trigonometric
  - Date & Time
    Date & Time
    
    Conversion
    
    Current Date and Time
    
    Date and Time Extraction
    
    Formatting
  - List & Map
    List & Map
    
    List and Map Concatenation
    
    List Manipulation
  - Geometry
    Geometry
    
    Coordinate Extraction
    
    Distance Calculation
    
    Point Creation
  - Others
    Others
    
    Null Handling
    
    Type Conversion
    
    Unique Identifier
Storages
Storages
- Introduction
- Supported Storages
  Supported Storages
- Developing Custom Storages
  Developing Custom Storages
  - Introduction
  - Understanding Store traits
    Understanding Store traits
    
    Store
    
    StoreMut
    
    AlterTable
    
    Transaction
    
    CustomFunction
    
    CustomFunctionMut
    
    Index
    
    IndexMut
    
    Metadata
  - Using the Test Suite
Archive
Archive
- Articles
  Articles
- Releases
  Releases

On this page

Todo

Introduction
AST Builder
Expressions

Nested¶

Todo¶

- NESTED: Represents a nested expression, allowing the use of complex and grouped expressions.