Please use the form below to provide your feedback. Because your feedback is valuable to us, the information you submit in this form is recorded in our issue tracking system (JIRA), which is publicly available. You can track the status of your feedback using the ticket number displayed in the dialog once you submit the form.

SQL++ for Mobile — Differences from Querybuilder

      +

      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

      Related Content

      How to . . .
      Learn more . . .
      Dive Deeper . . .

      Mobile Forum | Blog | Tutorials