Oracle SQL Standard

Worth mentioning deviations from the Oracle SQL Standard (Version 12c):

---

• drop_index_def

Oracle does not support a FROM table clause in the DROP INDEX rule.

sqlparse: drop_index_def -> DROP INDEX            FROM table 
          drop_index_def -> DROP INDEX index_name            
          drop_index_def -> DROP INDEX index_name FROM table 

Oracle:

---

• drop_table_def

Oracle does not support the DROP create_opts TABLE clause or a list of tables in the DROP TABLE rule.

sqlparse: drop_table_def -> DROP             TABLE        table_list                  
          drop_table_def -> DROP             TABLE        table_list restrict_cascade 
          drop_table_def -> DROP             TABLE exists table_list                  
          drop_table_def -> DROP             TABLE exists table_list restrict_cascade 
          drop_table_def -> DROP create_opts TABLE        table_list                  
          drop_table_def -> DROP create_opts TABLE        table_list restrict_cascade 
          drop_table_def -> DROP create_opts TABLE exists table_list                  
          drop_table_def -> DROP create_opts TABLE exists table_list restrict_cascade 

Oracle:

---

• function_ref

Oracle does support mixed notation for actual parameters, sqlparse supports only either positional or named actual parameters.

sqlparse: function_ref -> FUNS '(' fun_args            ')'              
          function_ref -> FUNS '(' fun_args_named      ')'              
          function_ref -> NAME                   '(' fun_args       ')' 
          function_ref -> NAME                   '(' fun_args_named ')' 
          function_ref -> NAME '.' NAME          '(' fun_args       ')' 
          function_ref -> NAME '.' NAME          '(' fun_args_named ')' 
          function_ref -> NAME '.' NAME '.' NAME '(' fun_args       ')' 
          function_ref -> NAME '.' NAME '.' NAME '(' fun_args_named ')'  

Oracle: Database PL/SQL Language Reference

---

• JSON

sqlparse supports JSONPath expressions that meet the conventions of jpparse in the following grammar rules:

column_ref -> NAME   JSON
column_ref -> NAME '.' NAME  JSON
column_ref -> NAME '.' NAME '.' NAME JSON

create_index_spec_column -> NAME JSON

function_ref -> function_ref JSON
  
query_term -> query_spec JSON
query_term -> '(' query_exp  ')' JSON

scalar_sub_exp -> '(' scalar_sub_exp ')' JSON

---