SQL++ for Mobile — Differences from Querybuilder

    February 2, 2025
    + 12

    Description — Differences between Couchbase Lite’s Querybuilder and SQL++ for Mobile
    Related Content — Predictive Queries | Live Queries | Indexing

    Couchbase Lite’s SQL++ for Mobile supports all QueryBuilder features, except Predictive Query and Index.
    See Table 1 for the features supported by SQL++ but not by QueryBuilder.

    Table 1. QueryBuilder Differences
    Category Components

    Conditional Operator

    CASE(WHEN …​ THEN …​ ELSE ..)

    Array Functions

    ARRAY_AGG ARRAY_AVG ARRAY_COUNT ARRAY_IFNULL ARRAY_MAX ARRAY_MIN ARRAY_SUM

    Conditional Functions

    IFMISSING IFMISSINGORNULL IFNULL MISSINGIF NULLIF Match Functions DIV IDIV ROUND_EVEN

    Pattern Matching Functions

    REGEXP_CONTAINS REGEXP_LIKE REGEXP_POSITION REGEXP_REPLACE

    Type Checking Functions

    ISARRAY ISATOM ISBOOLEAN ISNUMBER ISOBJECT ISSTRING TYPE

    Type Conversion Functions

    TOARRAY TOATOM TOBOOLEAN TONUMBER TOOBJECT TOSTRING