---
title: "Luminesce SQL keywords"
slug: "luminesce-sql-keywords"
updated: 2024-09-03T14:25:14Z
published: 2024-09-03T14:25:14Z
canonical: "support.lusid.com/luminesce-sql-keywords"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://support.lusid.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Luminesce SQL keywords

The following table lists keywords valid in [Luminesce SQL queries](/v1/docs/understanding-the-luminesce-sql-query-syntax).

Most keywords are inherited from the SQLite dialect of SQL. Some keywords are proprietary extensions.

| **Keyword** | **Explanation** |
| --- | --- |
| `ALL` | SQLite keywords defined at [https://www.sqlite.org/lang_keywords.html](https://www.sqlite.org/lang_keywords.html) |
| `AND` |
| `AS` |
| `ASC` |
| `BETWEEN` |
| `NOTBETWEEN` |
| `BY` |
| `CASE` |
| `CAST` |
| `CHECK` |
| `COLLATE` |
| `COLLATENOACCENT` |
| `COLLATENOCASE` |
| `COLLATEEXACT` |
| `CROSS` |
| `CURRENT` |
| `CURRENT_DATE` |
| `CURRENT_TIME` |
| `CURRENT_TIMESTAMP` |
| `DESC` |
| `DISTINCT` |
| `ELSE` |
| `END` |
| `EXCEPT` |
| `EXCLUDE` |
| `EXISTS` |
| `FALSE` |
| `FILTER` |
| `FIRST` |
| `FOLLOWING` |
| `FROM` |
| `FULL` |
| `GLOB` |
| `NOTGLOB` |
| `GROUP` |
| `GROUPS` |
| `HAVING` |
| `IN` |
| `NOTIN` |
| `INNER` |
| `INTERSECT` |
| `IS` |
| `ISNOT` |
| `ISNULL` |
| `ISNOTNULL` |
| `JOIN` |
| `LAST` |
| `LEFT` |
| `LIKE` |
| `NOTLIKE` |
| `LIMIT` |
| `NO` |
| `NOT` |
| `NULL` |
| `NULLS` |
| `OFFSET` |
| `ON` |
| `OR` |
| `ORDER` |
| `OTHERS` |
| `OUTER` |
| `OVER` |
| `PARTITION` |
| `PRAGMA` |
| `PRECEDING` |
| `RANGE` |
| `REGEXP` |
| `NOTREGEXP` |
| `REPLACE` |
| `ROW` |
| `ROWS` |
| `SELECT` |
| `THEN` |
| `TIES` |
| `TO` |
| `TRUE` |
| `TYPES` |
| `UNBOUNDED` |
| `UNION` |
| `USING` |
| `VALUES` |
| `WHEN` |
| `WHERE` |
| `WINDOW` |
| `WITH` |
| `USE` | FINBOURNE keywords |
| `ENDUSE` |
| `APPLY` |
| `WAIT` |
| `BIGINT` | Types used by the `TYPES` keyword ([more information](/v1/docs/understanding-the-luminesce-sql-query-syntax#type-conversion)) |
| `INT` |
| `BOOLEAN` |
| `DOUBLE` |
| `DECIMAL` |
| `TEXT` |
| `ABS` | SQLite scalar functions defined at [https://www.sqlite.org/lang_corefunc.html](https://www.sqlite.org/lang_corefunc.html) |
| `CHAR` |
| `COALESCE` |
| `HEX` |
| `IIF` |
| `IFNULL` |
| `INSTR` |
| `LENGTH` |
| `LIKELY` |
| `LOWER` |
| `LTRIM` |
| `MAX` |
| `MIN` |
| `NULLIF` |
| `PRINTF` |
| `QUOTE` |
| `RANDOM` |
| `RANDOMBLOB` |
| `ROUND` |
| `RTRIM` |
| `SOUNDEX` |
| `SUBSTR` |
| `TRIM` |
| `TYPEOF` |
| `UNICODE` |
| `UNLIKELY` |
| `UPPER` |
| `ZEROBLOB` |
| `DATE` | SQLite datetime functions defined at [https://www.sqlite.org/lang_datefunc.html](https://www.sqlite.org/lang_datefunc.html) |
| `TIME` |
| `DATETIME` |
| `JULIANDAY` |
| `STRFTIME` |
| `AVG` | SQLite aggregate functions defined at [https://www.sqlite.org/lang_aggfunc.html](https://www.sqlite.org/lang_aggfunc.html) |
| `COUNT` |
| `GROUP_CONCAT` |
| `SUM` |
| `TOTAL` |
| `ROW_NUMBER` | SQLite window functions defined at [https://www.sqlite.org/windowfunctions.html](https://www.sqlite.org/windowfunctions.html) |
| `RANK` |
| `DENSE_RANK` |
| `PERCENT_RANK` |
| `CUME_DIST` |
| `NTILE` |
| `LAG` |
| `LEAD` |
| `FIRST_VALUE` |
| `LAST_VALUE` |
| `NTH_VALUE` |
| `STDEV` | SQLite extension functions available from [https://www.sqlite.org/contrib/download/extension-functions.c?get=25](https://www.sqlite.org/contrib) |
| `VARIANCE` |
| `MODE` |
| `MEDIAN` |
| `LOWER_QUARTILE` |
| `UPPER_QUARTILE` |
| `REPLICATE` |
| `LEFTSTR` |
| `RIGHTSTR` |
| `REVERSE` |
| `PROPER` |
| `PADL` |
| `PADR` |
| `PADC` |
| `STRFITLER` |
| `CHARINDEX` |
| `LOG` |
| `LOG10` |
| `EXP` |
| `DIFFERENCE` |
| `POWER` |
| `SIGN` |
| `SQRT` |
| `SQUARE` |
| `CEIL` |
| `FLOOR` |
| `JSON` | SQL JSON functions defined at [https://www.sqlite.org/json1.html](https://www.sqlite.org/json1.html) |
| `JSON_ARRAY` |
| `JSON_ARRAY_LENGTH` |
| `JSON_EXTRACT` |
| `JSON_INSERT` |
| `JSON_OBJECT` |
| `JSON_PATCH` |
| `JSON_QUOTE` |
| `JSON_REMOVE` |
| `JSON_TYPE` |
| `JSON_VALID` |
| `JSON_GROUP_ARRAY` |
| `JSON_GROUP_OBJECT` |
| `QUANTILE` | FINBOURNE functions ([general](/v1/docs/supported-functions-in-luminesce-sql-queries#general-custom-functions) and [statistical](/v1/docs/supported-functions-in-luminesce-sql-queries#statistical-custom-functions)) |
| `CUMEPROD` |
| `SKEWNESS` |
| `KURTOSIS` |
| `ROOT_MEAN_SQUARE` |
| `HARMONIC_MEAN` |
| `GEOMETRIC_MEAN` |
| `ENTROPY` |
| `EMPIRICAL_CUME_DIST_FUNCTION` |
| `INTERQUARTILE_RANGE` |
| `INTERQUANTILE_RANGE` |
| `PEARSON_CORRELATION` |
| `SPEARMAN_RANK_CORRELATION` |
| `MEAN_SQUARED_ERROR` |
| `MEAN_ABSOLUTE_ERROR` |
| `MEDIAN_ABSOLUTE_DEVIATION` |
| `MEAN_FRACTIONAL_ABSOLUTE_ERROR` |
| `GAIN_LOSS_RATIO` |
| `SEMI_DEVIATION` |
| `DRAWDOWN` |
| `MAX_DRAWDOWN` |
| `MEAN_DRAWDOWN` |
| `DRAWDOWN_LENGTH` |
| `MAX_DRAWDOWN_LENGTH` |
| `MEAN_DRAWDOWN_LENGTH` |
| `COVARIANCE` |
| `WINDOW_STDEV` |
| `LINEAR_REGRESSION_ALPHA` |
| `LINEAR_REGRESSION_BETA` |
| `LINEAR_REGRESSION_ALPHA_ERROR` |
| `LINEAR_REGRESSION_BETA_ERROR` |
| `PRICES_TO_RETURNS` |
| `RETURNS_TO_PRICES` |
| `MEAN_STDEV_RATIO` |
| `COEFFICIENT_OF_VARIATION` |
| `MINKOWSKI_DISTANCE` |
| `CHEBYSHEV_DISTANCE` |
| `MANHATTAN_DISTANCE` |
| `EUCLIDEAN_DISTANCE` |
| `CANBERRA_DISTANCE` |
| `BRAYCURTIS_DISTANCE` |
| `COSINE_DISTANCE` |
| `PRECISION_SCORE` |
| `RECALL_SCORE` |
| `FBETA_SCORE` |
| `R_SQUARED` |
| `ADJUSTED_R_SQUARED` |
| `TO_DATE` |
| `THROW` |
| `PRINT` |
| `REGEXP_MATCH` |
| `REGEXP_MATCHES` |
| `REGEXP_MATCH_LOCATION` |
| `REGEXP_REPLACE` |
| `DAY_COUNT_DISPLAY` |
| `NOOP_FOR_TRANSLATION` |
| `CHECK_ACCESS` |
| `CHECK_REGISTRATION_ACCESS` |
| `EDIT_DISTANCE` |
| `IS_DATE` |
| `IS_NUMERIC` |
| `IS_INTEGER` |
| `TO_UTC` |
| `TO_ISO` |
| `FROM_UTC` |
| `CONVERT_TIMEZONE` |
| `GENERATE_HASH` |
| `CONTAINS_TOKEN` |
| `CONTAINS_TOKEN_STARTING_WITH` |