QuickSQL/QuickSQL_grammar at main · HamzaBenyazid/QuickSQL · GitHub

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
program : (view | table | new_line | comment | eps) { view | table | new_line | comment | eps }
table : ID table_directives {table_directives} new_line column { column }
view : "view" ID ID {ID} new_line
table_directives : colprefix_directive | select_directive | eps
colprefix_directive : /colprefix (ID|eps)
select_directive : /select
column : white_space ID type constraint new_line
type :  "num"
        | "int"
        | "d"
        | "ts"
        | "tstz"
        | "vc"
        | "vc" int
        | "clob"
        | "blob"
        | "json"
        | eps

constraint : pk_constraint
            | fk_constraint
            | check_constraint
            | not_null_constraint
            | between_constraint
            | index_constraint
            | default_constraint
            | unique_constraint
            | eps
unique_constrant: /unique
pk_constraint : /pk
fk_constraint : /fk ID
check_constraint : /check value{,value}
not_null_constraint : /nn
between_constraint : /between (number number | string string)
index_constraint : /index
default_constraint : /default value
comment : -- text new_line| [ text ]