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

annotate third_party/highlight/languages/sql.js @ 169:295ac2e5ec00

[MrJuneJune] Created separate target for generating html from md.

author	MrJuneJune <me@mrjunejune.com>
date	Mon, 19 Jan 2026 17:33:18 -0800
parents	2db6253f355d
children

rev	line source
157 2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	1 /! `sql` grammar compiled for Highlight.js 11.11.1 /
2db6253f355d [ThirdParty] Added highlight library for better readability on blog. June Park <parkjune1995@gmail.com> parents: diff changeset	2 (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 })();