LogoLogo
4.1
4.1
  • Developer Documentation
  • Install HarperDB
    • On Linux
  • Getting Started
  • Full API Documentation
  • HarperDB Studio
    • Create an Account
    • Log In & Password Reset
    • Resources (Marketplace, Drivers, Tutorials, & Example Code)
    • Organizations
    • Instances
    • Query Instance Data
    • Manage Schemas / Browse Data
    • Manage Charts
    • Manage Clustering
    • Manage Instance Users
    • Manage Instance Roles
    • Manage Functions
    • Instance Metrics
    • Instance Configuration
    • Instance Example Code
    • Enable Mixed Content
  • HarperDB Cloud
    • IOPS Impact on Performance
    • Instance Size Hardware Specs
    • Alarms
    • Verizon 5G Wavelength
  • Security
    • JWT Authentication
    • Basic Authentication
    • Configuration
    • Users & Roles
  • Clustering
    • Requirements and Definitions
    • Creating A Cluster User
    • Naming A Node
    • Enabling Clustering
    • Establishing Routes
    • Subscription Overview
    • Managing Subscriptions
    • Things Worth Knowing
  • Custom Functions
    • Requirements and Definitions
    • Create a Project
    • Define Routes
    • Define Helpers
    • Host A Static Web UI
    • Using NPM and GIT
    • Custom Functions Operations
    • Restarting the Server
    • Debugging a Custom Function
    • Custom Functions Templates
    • Example Projects
  • Add-ons and SDKs
    • Google Data Studio
  • SQL Guide
    • SQL Features Matrix
    • Insert
    • Update
    • Delete
    • Select
    • Joins
    • SQL Date Functions
    • SQL Reserved Word
    • SQL Functions
    • SQL JSON Search
    • SQL Geospatial Functions
      • geoArea
      • geoLength
      • geoDifference
      • geoDistance
      • geoNear
      • geoContains
      • geoEqual
      • geoCrosses
      • geoConvert
  • HarperDB CLI
  • Configuration File
  • Logging
  • Transaction Logging
  • Audit Logging
  • Jobs
  • Upgrade a HarperDB Instance
  • Reference
    • Storage Algorithm
    • Dynamic Schema
    • Data Types
    • Content Types/Data Formats
    • HarperDB Headers
    • HarperDB Limits
  • Support
  • Release Notes
    • HarperDB Tucker (Version 4)
      • 4.1.0
      • 4.0.6
      • 4.0.5
      • 4.0.4
      • 4.0.3
      • 4.0.2
      • 4.0.1
      • 4.0.0
    • HarperDB Monkey (Version 3)
      • 3.3.0
      • 3.2.1
      • 3.2.0
      • 3.1.5
      • 3.1.4
      • 3.1.3
      • 3.1.2
      • 3.1.1
      • 3.1.0
      • 3.0.0
    • HarperDB Penny (Version 2)
      • 2.3.1
      • 2.3.0
      • 2.2.3
      • 2.2.2
      • 2.2.0
      • 2.1.1
    • HarperDB Alby (Version 1)
      • 1.3.1
      • 1.3.0
      • 1.2.0
      • 1.1.0
Powered by GitBook

© HarperDB. All Rights Reserved

On this page
Export as PDF
  1. SQL Guide

SQL Features Matrix

PreviousSQL GuideNextInsert

Last updated 1 year ago

HarperDB provides access to most SQL functions, and we’re always expanding that list. Check below to see if we cover what you need. If not, feel free to .

INSERT

Values - multiple values supported

✔

Sub-SELECT

✗

UPDATE

SET

✔

Sub-SELECT

✗

Conditions

✔

Date Functions*

✔

Math Functions

✔

DELETE

FROM

✔

Sub-SELECT

✗

Conditions

✔

SELECT

Column SELECT

✔

Aliases

✔

Aggregator Functions

✔

Date Functions*

✔

Math Functions

✔

Constant Values

✔

Distinct

✔

Sub-SELECT

✗

FROM

Multi-table JOIN

✔

INNER JOIN

✔

LEFT OUTER JOIN

✔

LEFT INNER JOIN

✔

RIGHT OUTER JOIN

✔

RIGHT INNER JOIN

✔

FULL JOIN

✔

UNION

✗

Sub-SELECT

✗

TOP

✔

WHERE

Multi-Conditions

✔

Wildcards

✔

IN

✔

LIKE

✔

Bit-wise Operators AND, OR

✔

Bit-wise Operators NOT

✔

NULL

✔

BETWEEN

✔

EXISTS,ANY,ALL

✔

Compare columns

✔

Compare constants

✔

Date Functions*

✔

Math Functions

✔

Sub-SELECT

✗

GROUP BY

Multi-Column GROUP BY

✔

HAVING

Aggregate function conditions

✔

ORDER BY

Multi-Column ORDER BY

✔

Aliases

✔

Date Functions*

✔

Math Functions

✔

add a Feature Request