Skip to content
ScopeDBDocs
GuidesScopeQLAPI referenceRelease notes
Sign inStart free
ScopeDBDocs
Sign inStart free
  • Overview
  • Data model

    • Data types
    • Date and time
    • Semi-structured
    • Conversion
    • Computed columns
  • Commands

    • Overview
    • Query syntax
    • Query operators
      • Overview
      • Arithmetic
      • Comparison
      • Logical
      • Set operators
    • DDL
      • Overview
      • CREATE DATABASE
      • DROP DATABASE
      • CREATE SCHEMA
      • DROP SCHEMA
      • CREATE TABLE
      • DROP TABLE
      • ALTER TABLE
      • CREATE VIEW
      • DROP VIEW
      • SHOW TABLES
      • DESCRIBE TABLE
      • CREATE INDEX
      • DROP INDEX
    • DML
      • Overview
      • INSERT
      • DELETE
      • UPDATE
  • Functions

    • Overview
    • Aggregate
      • Overview
      • approx_count_distinct
      • approx_quantile
      • array_agg
      • avg
      • count
      • count_distinct
      • first, first_value
      • last, last_value
      • max
      • max_by
      • min
      • min_by
      • mode
      • object_agg
      • quantile
      • schema
      • stddev_pop
      • stddev_samp
      • sum
      • variance_pop
      • variance_samp
    • Conditional expression
      • Overview
      • IS [ NOT ]
    • Conversion
    • Date and time
      • Overview
      • ceil, floor
      • strftime, strptime
      • now
      • trunc
    • Numeric
      • Overview
      • abs
      • ceil
      • floor
      • ln, log
      • round
      • trunc
    • String
      • Overview
      • || (string concatenation)
      • contains
      • ends_with
      • length
      • lpad, rpad
      • ltrim
      • lower
      • md5
      • regexp_extract, regexp_extract_all
      • regexp_like
      • regexp_replace
      • repeat
      • replace
      • reverse
      • rtrim
      • search
      • search_ip
      • split
      • starts_with
      • String slicing
      • tokenize
      • trim
      • upper
    • Semi-structured data
      • Overview
      • {} (object construction)
      • [] (array construction)
      • [] (element access)
      • Array slicing
      • || (arrays and objects)
      • append
      • contains
      • dedup
      • exclude
      • keys
      • length
      • parse_json
      • to_json
      • typeof
    • Window
      • Overview
      • lag, lead
      • row_number
    • System
      • Overview
      • version

ScopeQL

On this page
  • Data model
  • Command reference
  • Function reference

This reference describes ScopeQL, the language used to query and manage data in ScopeDB.

Data model

Choose data types for your columns and expose reusable expressions through computed columns.

Command reference

Learn how to compose queries and manage the data they operate on.

Function reference

Find built-in operations for calculations and data analysis.

On this page

  • Data model
  • Command reference
  • Function reference
ScopeDB

Build

ScopeDB CloudPricingDocsGitHub

Explore

BlogBrand kitComponent library

Connect

CommunityContact usFeedback

© 2024–2026 ScopeDB. All rights reserved.