/home/mrjunejune/zenbu: third_party/highlight/es/languages/sql.js annotate

annotate third_party/highlight/es/languages/sql.js @ 180:3a4ebe4552bf

Remove playground file as it is not needed to be tracked.

author	June Park <parkjune1995@gmail.com>
date	Mon, 19 Jan 2026 08:05:02 -0800
parents	2db6253f355d
children

rev	line source
157 2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	1 /! `sql` grammar compiled for Highlight.js 11.11.1 /
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	2 var hljsGrammar = (function () {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	3 'use strict';
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	4
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	5 /*
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	6 Language: SQL
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	7 Website: https://en.wikipedia.org/wiki/SQL
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	8 Category: common, database
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	9 */
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	10
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	11 /*
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	12
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	13 Goals:
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	14
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	15 SQL is intended to highlight basic/common SQL keywords and expressions
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	16
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	17 - If pretty much every single SQL server includes supports, then it's a canidate.
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	18 - It is NOT intended to include tons of vendor specific keywords (Oracle, MySQL,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	19 PostgreSQL) although the list of data types is purposely a bit more expansive.
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	20 - For more specific SQL grammars please see:
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	21 - PostgreSQL and PL/pgSQL - core
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	22 - T-SQL - https://github.com/highlightjs/highlightjs-tsql
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	23 - sql_more (core)
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	24
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	25 */
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	26
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	27 function sql(hljs) {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	28 const regex = hljs.regex;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	29 const COMMENT_MODE = hljs.COMMENT('--', '$');
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	30 const STRING = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	31 scope: 'string',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	32 variants: [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	33 {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	34 begin: /'/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	35 end: /'/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	36 contains: [ { match: /''/ } ]
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	37 }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	38 ]
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	39 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	40 const QUOTED_IDENTIFIER = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	41 begin: /"/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	42 end: /"/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	43 contains: [ { match: /""/ } ]
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	44 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	45
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	46 const LITERALS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	47 "true",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	48 "false",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	49 // Not sure it's correct to call NULL literal, and clauses like IS [NOT] NULL look strange that way.
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	50 // "null",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	51 "unknown"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	52 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	53
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	54 const MULTI_WORD_TYPES = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	55 "double precision",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	56 "large object",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	57 "with timezone",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	58 "without timezone"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	59 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	60
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	61 const TYPES = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	62 'bigint',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	63 'binary',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	64 'blob',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	65 'boolean',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	66 'char',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	67 'character',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	68 'clob',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	69 'date',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	70 'dec',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	71 'decfloat',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	72 'decimal',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	73 'float',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	74 'int',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	75 'integer',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	76 'interval',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	77 'nchar',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	78 'nclob',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	79 'national',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	80 'numeric',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	81 'real',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	82 'row',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	83 'smallint',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	84 'time',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	85 'timestamp',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	86 'varchar',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	87 'varying', // modifier (character varying)
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	88 'varbinary'
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	89 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	90
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	91 const NON_RESERVED_WORDS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	92 "add",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	93 "asc",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	94 "collation",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	95 "desc",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	96 "final",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	97 "first",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	98 "last",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	99 "view"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	100 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	101
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	102 // https://jakewheat.github.io/sql-overview/sql-2016-foundation-grammar.html#reserved-word
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	103 const RESERVED_WORDS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	104 "abs",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	105 "acos",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	106 "all",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	107 "allocate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	108 "alter",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	109 "and",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	110 "any",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	111 "are",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	112 "array",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	113 "array_agg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	114 "array_max_cardinality",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	115 "as",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	116 "asensitive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	117 "asin",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	118 "asymmetric",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	119 "at",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	120 "atan",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	121 "atomic",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	122 "authorization",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	123 "avg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	124 "begin",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	125 "begin_frame",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	126 "begin_partition",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	127 "between",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	128 "bigint",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	129 "binary",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	130 "blob",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	131 "boolean",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	132 "both",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	133 "by",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	134 "call",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	135 "called",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	136 "cardinality",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	137 "cascaded",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	138 "case",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	139 "cast",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	140 "ceil",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	141 "ceiling",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	142 "char",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	143 "char_length",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	144 "character",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	145 "character_length",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	146 "check",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	147 "classifier",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	148 "clob",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	149 "close",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	150 "coalesce",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	151 "collate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	152 "collect",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	153 "column",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	154 "commit",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	155 "condition",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	156 "connect",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	157 "constraint",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	158 "contains",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	159 "convert",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	160 "copy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	161 "corr",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	162 "corresponding",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	163 "cos",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	164 "cosh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	165 "count",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	166 "covar_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	167 "covar_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	168 "create",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	169 "cross",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	170 "cube",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	171 "cume_dist",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	172 "current",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	173 "current_catalog",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	174 "current_date",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	175 "current_default_transform_group",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	176 "current_path",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	177 "current_role",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	178 "current_row",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	179 "current_schema",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	180 "current_time",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	181 "current_timestamp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	182 "current_path",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	183 "current_role",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	184 "current_transform_group_for_type",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	185 "current_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	186 "cursor",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	187 "cycle",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	188 "date",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	189 "day",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	190 "deallocate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	191 "dec",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	192 "decimal",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	193 "decfloat",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	194 "declare",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	195 "default",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	196 "define",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	197 "delete",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	198 "dense_rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	199 "deref",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	200 "describe",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	201 "deterministic",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	202 "disconnect",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	203 "distinct",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	204 "double",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	205 "drop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	206 "dynamic",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	207 "each",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	208 "element",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	209 "else",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	210 "empty",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	211 "end",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	212 "end_frame",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	213 "end_partition",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	214 "end-exec",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	215 "equals",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	216 "escape",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	217 "every",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	218 "except",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	219 "exec",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	220 "execute",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	221 "exists",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	222 "exp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	223 "external",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	224 "extract",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	225 "false",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	226 "fetch",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	227 "filter",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	228 "first_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	229 "float",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	230 "floor",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	231 "for",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	232 "foreign",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	233 "frame_row",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	234 "free",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	235 "from",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	236 "full",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	237 "function",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	238 "fusion",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	239 "get",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	240 "global",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	241 "grant",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	242 "group",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	243 "grouping",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	244 "groups",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	245 "having",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	246 "hold",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	247 "hour",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	248 "identity",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	249 "in",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	250 "indicator",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	251 "initial",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	252 "inner",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	253 "inout",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	254 "insensitive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	255 "insert",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	256 "int",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	257 "integer",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	258 "intersect",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	259 "intersection",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	260 "interval",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	261 "into",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	262 "is",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	263 "join",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	264 "json_array",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	265 "json_arrayagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	266 "json_exists",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	267 "json_object",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	268 "json_objectagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	269 "json_query",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	270 "json_table",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	271 "json_table_primitive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	272 "json_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	273 "lag",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	274 "language",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	275 "large",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	276 "last_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	277 "lateral",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	278 "lead",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	279 "leading",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	280 "left",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	281 "like",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	282 "like_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	283 "listagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	284 "ln",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	285 "local",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	286 "localtime",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	287 "localtimestamp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	288 "log",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	289 "log10",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	290 "lower",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	291 "match",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	292 "match_number",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	293 "match_recognize",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	294 "matches",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	295 "max",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	296 "member",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	297 "merge",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	298 "method",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	299 "min",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	300 "minute",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	301 "mod",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	302 "modifies",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	303 "module",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	304 "month",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	305 "multiset",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	306 "national",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	307 "natural",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	308 "nchar",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	309 "nclob",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	310 "new",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	311 "no",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	312 "none",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	313 "normalize",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	314 "not",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	315 "nth_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	316 "ntile",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	317 "null",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	318 "nullif",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	319 "numeric",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	320 "octet_length",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	321 "occurrences_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	322 "of",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	323 "offset",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	324 "old",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	325 "omit",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	326 "on",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	327 "one",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	328 "only",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	329 "open",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	330 "or",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	331 "order",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	332 "out",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	333 "outer",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	334 "over",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	335 "overlaps",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	336 "overlay",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	337 "parameter",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	338 "partition",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	339 "pattern",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	340 "per",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	341 "percent",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	342 "percent_rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	343 "percentile_cont",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	344 "percentile_disc",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	345 "period",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	346 "portion",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	347 "position",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	348 "position_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	349 "power",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	350 "precedes",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	351 "precision",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	352 "prepare",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	353 "primary",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	354 "procedure",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	355 "ptf",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	356 "range",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	357 "rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	358 "reads",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	359 "real",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	360 "recursive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	361 "ref",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	362 "references",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	363 "referencing",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	364 "regr_avgx",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	365 "regr_avgy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	366 "regr_count",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	367 "regr_intercept",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	368 "regr_r2",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	369 "regr_slope",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	370 "regr_sxx",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	371 "regr_sxy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	372 "regr_syy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	373 "release",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	374 "result",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	375 "return",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	376 "returns",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	377 "revoke",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	378 "right",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	379 "rollback",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	380 "rollup",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	381 "row",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	382 "row_number",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	383 "rows",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	384 "running",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	385 "savepoint",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	386 "scope",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	387 "scroll",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	388 "search",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	389 "second",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	390 "seek",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	391 "select",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	392 "sensitive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	393 "session_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	394 "set",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	395 "show",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	396 "similar",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	397 "sin",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	398 "sinh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	399 "skip",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	400 "smallint",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	401 "some",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	402 "specific",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	403 "specifictype",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	404 "sql",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	405 "sqlexception",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	406 "sqlstate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	407 "sqlwarning",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	408 "sqrt",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	409 "start",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	410 "static",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	411 "stddev_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	412 "stddev_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	413 "submultiset",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	414 "subset",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	415 "substring",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	416 "substring_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	417 "succeeds",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	418 "sum",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	419 "symmetric",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	420 "system",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	421 "system_time",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	422 "system_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	423 "table",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	424 "tablesample",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	425 "tan",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	426 "tanh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	427 "then",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	428 "time",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	429 "timestamp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	430 "timezone_hour",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	431 "timezone_minute",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	432 "to",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	433 "trailing",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	434 "translate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	435 "translate_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	436 "translation",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	437 "treat",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	438 "trigger",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	439 "trim",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	440 "trim_array",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	441 "true",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	442 "truncate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	443 "uescape",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	444 "union",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	445 "unique",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	446 "unknown",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	447 "unnest",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	448 "update",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	449 "upper",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	450 "user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	451 "using",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	452 "value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	453 "values",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	454 "value_of",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	455 "var_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	456 "var_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	457 "varbinary",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	458 "varchar",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	459 "varying",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	460 "versioning",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	461 "when",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	462 "whenever",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	463 "where",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	464 "width_bucket",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	465 "window",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	466 "with",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	467 "within",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	468 "without",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	469 "year",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	470 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	471
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	472 // these are reserved words we have identified to be functions
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	473 // and should only be highlighted in a dispatch-like context
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	474 // ie, array_agg(...), etc.
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	475 const RESERVED_FUNCTIONS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	476 "abs",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	477 "acos",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	478 "array_agg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	479 "asin",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	480 "atan",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	481 "avg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	482 "cast",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	483 "ceil",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	484 "ceiling",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	485 "coalesce",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	486 "corr",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	487 "cos",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	488 "cosh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	489 "count",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	490 "covar_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	491 "covar_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	492 "cume_dist",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	493 "dense_rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	494 "deref",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	495 "element",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	496 "exp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	497 "extract",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	498 "first_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	499 "floor",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	500 "json_array",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	501 "json_arrayagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	502 "json_exists",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	503 "json_object",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	504 "json_objectagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	505 "json_query",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	506 "json_table",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	507 "json_table_primitive",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	508 "json_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	509 "lag",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	510 "last_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	511 "lead",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	512 "listagg",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	513 "ln",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	514 "log",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	515 "log10",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	516 "lower",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	517 "max",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	518 "min",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	519 "mod",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	520 "nth_value",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	521 "ntile",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	522 "nullif",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	523 "percent_rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	524 "percentile_cont",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	525 "percentile_disc",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	526 "position",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	527 "position_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	528 "power",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	529 "rank",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	530 "regr_avgx",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	531 "regr_avgy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	532 "regr_count",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	533 "regr_intercept",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	534 "regr_r2",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	535 "regr_slope",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	536 "regr_sxx",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	537 "regr_sxy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	538 "regr_syy",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	539 "row_number",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	540 "sin",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	541 "sinh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	542 "sqrt",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	543 "stddev_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	544 "stddev_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	545 "substring",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	546 "substring_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	547 "sum",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	548 "tan",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	549 "tanh",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	550 "translate",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	551 "translate_regex",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	552 "treat",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	553 "trim",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	554 "trim_array",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	555 "unnest",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	556 "upper",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	557 "value_of",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	558 "var_pop",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	559 "var_samp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	560 "width_bucket",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	561 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	562
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	563 // these functions can
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	564 const POSSIBLE_WITHOUT_PARENS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	565 "current_catalog",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	566 "current_date",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	567 "current_default_transform_group",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	568 "current_path",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	569 "current_role",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	570 "current_schema",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	571 "current_transform_group_for_type",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	572 "current_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	573 "session_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	574 "system_time",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	575 "system_user",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	576 "current_time",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	577 "localtime",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	578 "current_timestamp",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	579 "localtimestamp"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	580 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	581
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	582 // those exist to boost relevance making these very
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	583 // "SQL like" keyword combos worth +1 extra relevance
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	584 const COMBOS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	585 "create table",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	586 "insert into",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	587 "primary key",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	588 "foreign key",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	589 "not null",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	590 "alter table",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	591 "add constraint",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	592 "grouping sets",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	593 "on overflow",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	594 "character set",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	595 "respect nulls",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	596 "ignore nulls",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	597 "nulls first",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	598 "nulls last",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	599 "depth first",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	600 "breadth first"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	601 ];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	602
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	603 const FUNCTIONS = RESERVED_FUNCTIONS;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	604
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	605 const KEYWORDS = [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	606 ...RESERVED_WORDS,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	607 ...NON_RESERVED_WORDS
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	608 ].filter((keyword) => {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	609 return !RESERVED_FUNCTIONS.includes(keyword);
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	610 });
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	611
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	612 const VARIABLE = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	613 scope: "variable",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	614 match: /@[a-z0-9][a-z0-9_]*/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	615 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	616
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	617 const OPERATOR = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	618 scope: "operator",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	619 match: /[-+*/=%^~]\|&&?\|\\|\\|?\|!=?\|<(?:=>?\|<\|>)?\|>[>=]?/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	620 relevance: 0,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	621 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	622
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	623 const FUNCTION_CALL = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	624 match: regex.concat(/\b/, regex.either(...FUNCTIONS), /\s*\(/),
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	625 relevance: 0,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	626 keywords: { built_in: FUNCTIONS }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	627 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	628
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	629 // turns a multi-word keyword combo into a regex that doesn't
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	630 // care about extra whitespace etc.
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	631 // input: "START QUERY"
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	632 // output: /\bSTART\s+QUERY\b/
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	633 function kws_to_regex(list) {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	634 return regex.concat(
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	635 /\b/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	636 regex.either(...list.map((kw) => {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	637 return kw.replace(/\s+/, "\\s+")
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	638 })),
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	639 /\b/
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	640 )
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	641 }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	642
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	643 const MULTI_WORD_KEYWORDS = {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	644 scope: "keyword",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	645 match: kws_to_regex(COMBOS),
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	646 relevance: 0,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	647 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	648
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	649 // keywords with less than 3 letters are reduced in relevancy
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	650 function reduceRelevancy(list, {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	651 exceptions, when
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	652 } = {}) {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	653 const qualifyFn = when;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	654 exceptions = exceptions \|\| [];
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	655 return list.map((item) => {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	656 if (item.match(/\\|\d+$/) \|\| exceptions.includes(item)) {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	657 return item;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	658 } else if (qualifyFn(item)) {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	659 return `${item}\|0`;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	660 } else {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	661 return item;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	662 }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	663 });
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	664 }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	665
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	666 return {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	667 name: 'SQL',
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	668 case_insensitive: true,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	669 // does not include {} or HTML tags `</`
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	670 illegal: /[{}]\|<\//,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	671 keywords: {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	672 $pattern: /\b[\w\.]+/,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	673 keyword:
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	674 reduceRelevancy(KEYWORDS, { when: (x) => x.length < 3 }),
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	675 literal: LITERALS,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	676 type: TYPES,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	677 built_in: POSSIBLE_WITHOUT_PARENS
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	678 },
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	679 contains: [
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	680 {
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	681 scope: "type",
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	682 match: kws_to_regex(MULTI_WORD_TYPES)
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	683 },
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	684 MULTI_WORD_KEYWORDS,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	685 FUNCTION_CALL,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	686 VARIABLE,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	687 STRING,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	688 QUOTED_IDENTIFIER,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	689 hljs.C_NUMBER_MODE,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	690 hljs.C_BLOCK_COMMENT_MODE,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	691 COMMENT_MODE,
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	692 OPERATOR
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	693 ]
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	694 };
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	695 }
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	696
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	697 return sql;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	698
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	699 })();
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	700 ;
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	701 export default hljsGrammar;