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
comment "-- Notes by their count."
keyword "SELECT"
punctuation ","
function "COUNT"
punctuation "("
operator "*"
punctuation ")"
keyword "AS"
keyword "FROM"
keyword "LEFT"
keyword "JOIN"
keyword "ON"
operator "="
keyword "WHERE"
keyword "LIKE"
string "'it''s%'"
keyword "AND"
operator ">"
variable "$1"
comment "/* recent */"
keyword "AND"
keyword "IS"
keyword "NOT"
constant.language "NULL"
keyword "GROUP"
keyword "BY"
keyword "CREATE"
keyword "TABLE"
variable "\"my notes\""
punctuation "("
type.builtin "INTEGER"
keyword "PRIMARY"
keyword "KEY"
punctuation ","
type.builtin "text"
punctuation ");"
keyword "select"
keyword.control "case"
keyword.control "when"
keyword.control "then"
number "1"
keyword.control "else"
number "2.5"
keyword.control "end"
keyword "from"
punctuation ";"