---
title: Reserved Keywords
description: This topic lists the SQL++ for Capella Analytics reserved keywords.
pubDate: 2026-08-17T09:53:44.266Z
antora:
  editUrl: https://github.com/couchbaselabs/docs-columnar/edit/main/modules/sqlpp/pages/reserved_keywords.adoc
  xref: xref:analytics:sqlpp:reserved_keywords.adoc[]
---

[Consult the llms.txt file for a full list of contents](/llms.txt)
[View original HTML](/analytics/sqlpp/reserved_keywords.html)

# Reserved Keywords

> This topic lists the SQL++ for Capella Analytics reserved keywords. 

To include an identifier that is the same as a reserved keyword in a query, you must escape, or delimit, it with backtick (``` `` ```) characters.

You must also delimit an identifier if it contains the dash `-` character, which is also used as an [operator](2%5Fexpr.md#Operator%5Fexpressions) symbol.

For an example of the error that occurs when you do not escape a reserved keyword, see [Syntax Errors](4%5Ferror.md#Syntax%5Ferrors).

> [!TIP]
> The following keywords are reserved regardless of the case you use to enter them. Identifiers are case sensitive.

|            |               |            |            |            |           |
| ---------- | ------------- | ---------- | ---------- | ---------- | --------- |
| ALL        | AND           | ANY        | APPLY      | AS         | ASC       |
| AT         | AUTOGENERATED | BETWEEN    | BTREE      | BUCKET     | BY        |
| CASE       | CLOSED        | COLLECTION | COMPACTION | COMPACT    | CONNECT   |
| CORRELATE  | CREATE        | DATABASE   | DATASET    | DATAVERSE  |           |
| DECLARE    | DEFINITION    | DELETE     | DESC       | DISCONNECT |           |
| DISTINCT   | DROP          | ELEMENT    | ELSE       | END        | ENFORCED  |
| EVERY      | EXCEPT        | EXISTS     | EXPLAIN    | EXTERNAL   | FEED      |
| FILTER     | FLATTEN       | FOR        | FROM       | FULL       | FUNCTION  |
| GROUP      | HAVING        | HINTS      | IF         | INTO       | IN        |
| INDEX      | INGESTION     | INNER      | INSERT     | INTERNAL   | INTERSECT |
| IS         | JOIN          | KEYWORD    | KEY        | LEFT       | LETTING   |
| LET        | LIKE          | LIMIT      | LINK       | LOAD       | NGRAM     |
| NODEGROUP  | NOT           | OFFSET     | ON         | OPEN       | OR        |
| ORDER      | OUTER         | OUTPUT     | OVER       | PATH       | POLICY    |
| PRE-SORTED | PRIMARY       | RAW        | REFRESH    | RETURN     | RTREE     |
| RUN        | SATISFIES     | SECONDARY  | SELECT     | SET        | SHADOW    |
| SOME       | SYNONYM       | TEMPORARY  | THEN       | TYPE       | TO        |
| UNION      | UNKNOWN       | UNNEST     | UPDATE     | USE        | USING     |
| VALUE      | WHEN          | WHERE      | WITH       | WRITE      |           |