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

annotate third_party/highlight/languages/sql.js @ 279:b3b547563ec7

Add Google connector service and agent wiki Implement the C/Seobeo Google Drive and Gmail connector with encrypted OAuth storage, Zenbu authentication, browser testing, AI tool discovery, chunked HTTP decoding, and Bazel coverage. Consolidate repository guidance into progressive wiki documentation and enforce arena-first allocation for new first-party C code. Co-authored-by: Copilot <[email protected]> Copilot-Session: 84c338fd-0939-4bb3-b7f3-1062eb213e5d

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