-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathpresto_keywords.conf
149 lines (144 loc) · 1.98 KB
/
presto_keywords.conf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
--
-- Author: Hari Sekhon
-- Date: 2020-01-01 14:37:21 +0000 (Wed, 01 Jan 2020)
--
-- vim:ts=2:sts=2:sw=2:et:filetype=sql
--
-- https://github.com/HariSekhon/SQL-keywords
--
-- License: see accompanying LICENSE file
--
-- If you're using my code you're welcome to connect with me on LinkedIn
-- and optionally send me feedback to help improve or steer this or other code I publish
--
-- https://www.linkedin.com/in/HariSekhon
--
-- prestocase.pl configuration file
-- List of keywords to re-case for Presto SQL DB
-- Regex one per line of keywords to re-case by literal replacement
-- whitespace is converted to \s+ for matching so this list can look cleaner
-- leading/trailing whitespace is automatically trimmed
-- don't specify functions such as COUNT() with brackets since brackets are added as one of several possible keyword boundaries
-- https://prestosql.io/docs/current/language/reserved.html
ALTER
AND
AS
BETWEEN
BY
CASE
CAST
CONSTRAINT
CREATE
CROSS
CUBE
CURRENT_DATE
CURRENT_PATH
CURRENT_ROLE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
DEALLOCATE
DELETE
DESCRIBE
DISTINCT
DROP
ELSE
END
ESCAPE
EXCEPT
EXECUTE
EXISTS
EXTRACT
FALSE
FOR
FROM
FULL
GROUP
GROUPING
HAVING
IN
INNER
INSERT
INTERSECT
INTO
IS
JOIN
LEFT
LIKE
LOCALTIME
LOCALTIMESTAMP
NATURAL
NORMALIZE
NOT
NULL
ON
OR
ORDER
OUTER
PREPARE
RECURSIVE
RIGHT
ROLLUP
SELECT
TABLE
THEN
TRUE
UESCAPE
UNION
UNNEST
USING
VALUES
WHEN
WHERE
WITH
-- https://prestosql.io/docs/current/sql.html
ALTER SCHEMA
ALTER TABLE
ALTER VIEW
ANALYZE
CALL
COMMENT
COMMIT
CREATE ROLE
CREATE SCHEMA
CREATE TABLE
CREATE TABLE AS
CREATE VIEW
DEALLOCATE PREPARE
DELETE
DESCRIBE
DESCRIBE INPUT
DESCRIBE OUTPUT
DROP ROLE
DROP SCHEMA
DROP TABLE
DROP VIEW
EXECUTE
EXPLAIN
EXPLAIN ANALYZE
GRANT
GRANT ROLES
INSERT
PREPARE
RESET SESSION
REVOKE
REVOKE ROLES
ROLLBACK
SELECT
SET ROLE
SET SESSION
SHOW CATALOGS
SHOW COLUMNS
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW FUNCTIONS
SHOW GRANTS
SHOW ROLE GRANTS
SHOW ROLES
SHOW SCHEMAS
SHOW SESSION
SHOW STATS
SHOW TABLES
START TRANSACTION
USE
VALUES