couchbase_n1ql_keywords.conf

--
--  Author: Hari Sekhon
--  Date: 2016-01-20 19:19:24 +0000 (Wed, 20 Jan 2016)
--
--  vim:ts=2:sts=2:sw=2:et:filetype=sql
--
--  https://github.com/HariSekhon/SQL-keywords
--
--  License: see accompanying LICENSE file
--
--  If you're using my code you're welcome to connect with me on LinkedIn
--  and optionally send me feedback to help improve or steer this or other code I publish
--
--  https://www.linkedin.com/in/HariSekhon
--

-- List of keywords to re-case Couchbase N1QL keywords

-- used by n1qlcase.pl / couchbase_n1qlcase.pl

-- written in the background while sitting in N1QL workshop @ Couchbase office

-- Regex one per line of keywords to re-case by literal replacement
-- whitespace is converted to \s+ for matching so this list can look cleaner
-- leading/trailing whitespace is automatically trimmed
-- don't specify functions such as COUNT() with brackets since brackets are added as one of several possible keyword boundaries

-- keywords are all over the place

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/reservedwords.html
ALL
ALTER
ANALYZE
AND
ANY
ARRAY
AS
ASC
BEGIN
BETWEEN
BINARY
BOOLEAN
BREAK
BUCKET
BY
CALL
CASE
CAST
CLUSTER
COLLATE
COLLECTION
COMMIT
CONNECT
CONTINUE
CORRELATE
CREATE
DATABASE
DATASET
DATASTORE
DECLARE
DELETE
DERIVED
DESC
DESCRIBE
DISTINCT
DO
DROP
EACH
ELEMENT
ELSE
END
EVERY
EXCEPT
EXCLUDE
EXECUTE
EXISTS
EXPLAIN
FALSE
FIRST
FLATTEN
FOR
FROM
FUNCTION
GRANT
GROUP
GSI
HAVING
IF
IN
INCLUDE
INDEX
INLINE
INNER
INSERT
INTERSECT
INTO
IS
JOIN
KEY
KEYS
KEYSPACE
LAST
LEFT
LET
LETTING
LIKE
LIMIT
LSM
MAP
MAPPING
MATCHED
MATERIALIZED
MERGE
MINUS
MISSING
NAMESPACE
NEST
NOT
NULL
NUMBER
OFFSET
ON
OPTION
OR
ORDER
OUTER
OVER
PARSE
PARTITION
PASSWORD
PATH
POOL
PREPARE
PRIMARY
PRIVATE
PRIVILEGE
PROCEDURE
PUBLIC
RAW
REALM
REDUCE
RENAME
RETURN
RETURNING
REVOKE
RIGHT
ROLE
ROLLBACK
SATISFIES
SCHEMA
SELECT
SELF
SET
SHOW
SOME
START
STATISTICS
STRING
SYSTEM
THEN
TO
TRANSACTION
TRIGGER
TRUE
TRUNCATE
UNDER
UNION
UNIQUE
UNNEST
UNSET
UPDATE
UPSERT
USE
USER
USING
VALIDATE
VALUE
VALUED
VALUES
VIEW
WHEN
WHERE
WHILE
WITH
WITHIN
WORK
XOR

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/aggregatefun.html
ARRAY_AGG
AVG
COUNT
MAX
MIN
SUM

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/arrayfun.html
ARRAY_APPEND
ARRAY_AVG
ARRAY_CONCAT
ARRAY_CONTAINS
ARRAY_COUNT
ARRAY_DISTINCT
ARRAY_IFNULL
ARRAY_LENGTH
ARRAY_MAX
ARRAY_MIN
ARRAY_POSITION
ARRAY_PREPEND
ARRAY_PUT
ARRAY_RANGE
ARRAY_REMOVE
ARRAY_REPEAT
ARRAY_REPLACE
ARRAY_REVERSE
ARRAY_SORT
ARRAY_SUM

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/comparisonfun.html
GREATEST
LEAST

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/condfununknown.html
IFMISSING
IFMISSINGORNULL
IFNULL
MISSINGIF
NULLIF

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/condfunnum.html
IFINF
IFNAN
IFNANORINF
NANIF
NEGINFIF
POSINFIF

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/datefun.html
CLOCK_MILLIS
CLOCK_STR
DATE_ADD_MILLIS
DATE_ADD_STR
DATE_DIFF_MILLIS
DATE_DIFF_STR
DATE_PART_MILLIS
DATE_PART_STR
DATE_TRUNC_MILLIS
DATE_TRUNC_STR
MILLIS
MILLIS_TO_STR
MILLIS_TO_UTC
MILLIS_TO_ZONE_NAME
NOW_MILLIS
NOW_STR
STR_TO_MILLIS
STR_TO_UTC
STR_TO_ZONE_NAME

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/jsonfun.html
DECODE_JSON
ENCODED_SIZE
ENCODE_JSON
POLY_LENGTH

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/metafun.html
BASE64
META
UUID

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/numericfun.html
ABS
ACOS
ASIN
ATAN
ATAN2
CEIL
COS
DEGREES
E
EXP
FLOOR
LN
LOG
PI
POWER
RADIANS
RANDOM
ROUND
SIGN
SIN
SQRT
TAN
TRUNC

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/objectfun.html
OBJECT_LENGTH
OBJECT_NAMES
OBJECT_PAIRS
OBJECT_VALUES

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/patternmatchingfun.html
REGEXP_CONTAINS
REGEXP_LIKE
REGEXP_POSITION
REGEXP_REPLACE

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/stringfun.html
CONTAINS
INITCAP
LENGTH
LOWER
LTRIM
POSITION
REPEAT
REPLACE
RTRIM
SPLIT
SUBSTR
TITLE
TRIM
UPPER

-- http://developer.couchbase.com/documentation/server/4.0/n1ql/n1ql-language-reference/typefun.html
ISARRAY
ISATOM
ISBOOLEAN
ISNUMBER
ISOBJECT
ISSTRING
TYPE
TOARRAY
TOATOM
TOBOOLEAN
TONUMBER
TOOBJECT
TOSTRING