insert grammar

#INSERT# insert into col_name ( #COL_NAMES_LIST# ) #CONTINUE_INSERT# #END#

#CONTINUE_INSERT# #SIMPLE_INSERT#
! #INSERT_INTO_SELECT#

#SIMPLE_INSERT# values ( #COL_VAL_LIST# )

#COL_VAL_LIST# #LITERAL_IN_BRACKETS# #CONTINUE_COL_VAL_LIST#

#LITERAL_IN_BRACKETS# ( #LITERAL# )
! #LITERAL#

#CONTINUE_COL_VAL_LIST# , #COL_VAL_LIST#
!

#INSERT_INTO_SELECT# #SELECT_STATEMENT#

#END# ;
!

#SELECT_STATEMENT# select #DISTINCT# #EXPRESSION_LIST#  from #TABLE# #SELECT_CONSTRAINT# #ORDER_BY# #GROUP_BY#

#DISTINCT# distinct
!

#SELECT_CONSTRAINT# on #BOOL_EXPRESSION#
! using ( #COL_NAMES_LIST# )
! #WHERE#
!

#ORDER_BY# order by #EXPRESSION# #COMPARATOR#
!

#COL_NAMES_LIST# #COLUMN_NAME# #CONTINUE_COL_NAMES_LIST#

#CONTINUE_COL_NAMES_LIST# , #COL_NAMES_LIST#
!

#WHERE# where #BOOL_EXPRESSION#

#GROUP_BY# group by #COLUMN_NAME# #HAVING# #ORDER_BY#
!

#HAVING# having #BOOL_EXPRESSION#
!

#COMPARATOR# asc
! desc
!

#BOOL_EXPRESSION# #BOOL_TERM# #CONTINUE_BOOL_EXPRESSION#
! ( #BOOL_EXPRESSION# ) #CONTINUE_BOOL_EXPRESSION#

#CONTINUE_BOOL_EXPRESSION# #BOOL_OPERATOR# #BOOL_EXPRESSION#
!

#BOOL_OPERATOR# and
! or

#BOOL_TERM# #EXPRESSION# #KILL_NOT_LL1#
! not #BOOL_TERM#
! exists ( #SELECT_STATEMENT# )

#KILL_NOT_LL1# #BOOL_TERM_OPERATOR# #EXPRESSION#
! in ( #SELECT_STATEMENT# )
! not in ( #SELECT_STATEMENT# )
!

#BOOL_TERM_OPERATOR# =
! >
! <
! >=
! <=
! <>

#COLUMN_NAME# col_name #ALLIAS#

#TABLE# #TABLE_NAME#  #JOIN#
! ( #TABLE# )   #JOIN#

#ALLIAS# as name
!


#JOIN# #IJ# #TABLE# on #ON_WHAT#
! , #TABLE#
!

#ON_WHAT# #ON_ROW# = #ON_ROW#

#ON_ROW# #TABLE_NAME# . #COLUMN_NAME#
! #COLUMN_NAME#


#IJ# #JOIN_TYPE# join

#JOIN_TYPE# inner
! left
! right
! full
!

#TABLE_NAME# table_name #ALLIAS#

#EXPRESSION_LIST# #EXPRESSION# #CONTINUE_EXPRESSION#

#CONTINUE_EXPRESSION# , #EXPRESSION_LIST#
!

#EXPRESSION# #TERM# #CONT_EXPR#

#CONT_EXPR# #EXPR_OP# #EXPRESSION#
!

#EXPR_OP# +
! -
! *
! /

#TERM# #LITERAL# #ALLIAS#
! #POS_TABLE_NAME# #POS_COL#
! #FUNCTION# ( #EXPRESSION# ) #ALLIAS#
! - #TERM#

#LITERAL# DIGIT
! LITER_STR
! Double

#FUNCTION# FUNC_NAME

#POS_TABLE_NAME# #TABLE_NAME# #POS_DOT#
!

#POS_DOT# .
!

#POS_COL# #COLUMN_NAME#
! *