Luminesce SQL keywords · Customer Self-Service

Views:

Related resources:

Explanation

Tutorials

How-to guides

Providers

Luminesce > Reference

The following table lists keywords valid in Luminesce SQL queries.

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

Keyword	Explanation
`ALL`	SQLite keywords defined at http://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)
`INT`
`BOOLEAN`
`DOUBLE`
`DECIMAL`
`TEXT`
`ABS`	SQLite scalar functions defined at 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
`TIME`
`DATETIME`
`JULIANDAY`
`STRFTIME`
`AVG`	SQLite aggregate functions defined at 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
`RANK`
`DENSE_RANK`
`PERCENT_RANK`
`CUME_DIST`
`NTILE`
`LAG`
`LEAD`
`FIRST_VALUE`
`LAST_VALUE`
`NTH_VALUE`
`STDEV`	SQLite extension functions available from http://www.sqlite.org/contrib/download/extension-functions.c?get=25
`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
`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 and statistical)
`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`