stackrender
diff --git a/‎ast/postgresql.ts‎
Lines changed: 21 additions & 7 deletions b/‎ast/postgresql.ts‎
Lines changed: 21 additions & 7 deletions
diff --git a/‎package.json‎
Lines changed: 1 addition & 1 deletion b/‎package.json‎
Lines changed: 1 addition & 1 deletion
diff --git a/‎pegjs/postgresql.pegjs‎
Lines changed: 2 additions & 0 deletions b/‎pegjs/postgresql.pegjs‎
Lines changed: 2 additions & 0 deletions
@@ -7,7 +7,7 @@
 
 export type start = multiple_stmt | cmd_stmt | crud_stmt;
 
-export type cmd_stmt = drop_stmt | create_stmt | truncate_stmt | rename_stmt | call_stmt | use_stmt | alter_stmt | set_stmt | lock_stmt;
+export type cmd_stmt = drop_stmt | create_stmt | truncate_stmt | rename_stmt | call_stmt | use_stmt | alter_stmt | set_stmt | lock_stmt | show_stmt;
 
 export type create_stmt = create_table_stmt | create_constraint_trigger | create_extension_stmt | create_index_stmt | create_sequence | create_db_stmt;
 
@@ -448,6 +448,13 @@ export interface call_stmt_node {
 
 export type call_stmt = AstStatement<call_stmt_node>;
 
+export interface show_stmt_node {
+          type: 'show';
+          keyword: 'tables';
+        }
+
+export type show_stmt = AstStatement<show_stmt_node>;
+
 export interface select_stmt_node extends select_stmt_nake  {
        parentheses_symbol: true;
       }
@@ -486,7 +493,7 @@ export type array_index = { brackets: boolean, number: number };
 
 export type expr_item = expr & { array_index: array_index };
 
-export type column_list_item = { type: 'cast'; expr: expr; symbol: '::'; target: data_type;  as?: null; } | { type: 'star_ref'; expr: column_ref; as: null; } | { type: 'expr'; expr: expr; as?: alias_clause; };
+export type column_list_item = { expr: expr; as: null; } | { type: 'cast'; expr: expr; symbol: '::'; target: data_type;  as?: null; } | { type: 'star_ref'; expr: column_ref; as: null; } | { type: 'expr'; expr: expr; as?: alias_clause; };
 
 
 
@@ -547,7 +554,7 @@ export type on_clause = expr;
 
 
 
-export type where_clause = expr;
+export type where_clause = binary_expr;
 
 
 
@@ -656,9 +663,16 @@ export type interval_expr = { type: 'interval', expr: expr; unit: interval_unit;
 
 
 
+
+
 export type case_expr = {
           type: 'case';
-          expr?: expr;
+          expr:  null;
+          // nb: Only the last element is a case_else
+          args: (case_when_then | case_else)[];
+        } | {
+          type: 'case';
+          expr: expr;
           // nb: Only the last element is a case_else
           args: (case_when_then | case_else)[];
         };
@@ -696,8 +710,6 @@ export type unary_expr = {
 
 export type or_and_where_expr = binary_expr;
 
-export type parentheses_or_expr = binary_expr | or_expr;
-
 export type or_expr = binary_expr;
 
 export type and_expr = binary_expr;
@@ -750,9 +762,11 @@ export type multiplicative_operator = "*" | "/" | "%";
 
 export type primary = cast_expr | literal | aggr_func | window_func | func_call | case_expr | interval_expr | column_ref | param | expr | binary_expr | expr_list | var_decl | { type: 'origin'; value: string; };
 
+export type string_constants_escape = { type: 'origin'; value: string; };
+
 
 
-export type column_ref = {
+export type column_ref = string_constants_escape | {
         type: 'column_ref';
         table: ident;
         column: column | '*';
 
@@ -1,6 +1,6 @@
 {
   "name": "node-sql-parser",
-  "version": "3.8.4",
+  "version": "3.9.0",
   "description": "simple node sql parser",
   "main": "index.js",
   "types": "types.d.ts",
 
@@ -1708,6 +1708,7 @@ expr_item
   }
 column_list_item
   = c:string_constants_escape {
+    // => { expr: expr; as: null; }
     return { expr: c, as: null }
   }
   / e:expr_item s:KW_DOUBLE_COLON t:data_type __ alias:alias_clause? {
@@ -2605,6 +2606,7 @@ primary
 
 string_constants_escape
   = 'E'i"'" __ n:single_char* __ "'" {
+    // => { type: 'origin'; value: string; }
     return {
       type: 'origin',
       value: `E'${n.join('')}'`
Original file line number	Diff line number	Diff line change
`@@ -1,6 +1,6 @@`
`1`	`1`	`{`
`2`	`2`	`"name": "node-sql-parser",`
`3`		`- "version": "3.8.4",`
	`3`	`+ "version": "3.9.0",`
`4`	`4`	`"description": "simple node sql parser",`
`5`	`5`	`"main": "index.js",`
`6`	`6`	`"types": "types.d.ts",`
Original file line number	Diff line number	Diff line change
`@@ -1708,6 +1708,7 @@ expr_item`
`1708`	`1708`	`}`
`1709`	`1709`	`column_list_item`
`1710`	`1710`	`= c:string_constants_escape {`
	`1711`	`+ // => { expr: expr; as: null; }`
`1711`	`1712`	`return { expr: c, as: null }`
`1712`	`1713`	`}`
`1713`	`1714`	`/ e:expr_item s:KW_DOUBLE_COLON t:data_type __ alias:alias_clause? {`
`@@ -2605,6 +2606,7 @@ primary`
`2605`	`2606`
`2606`	`2607`	`string_constants_escape`
`2607`	`2608`	`= 'E'i"'" __ n:single_char* __ "'" {`
	`2609`	`+ // => { type: 'origin'; value: string; }`
`2608`	`2610`	`return {`
`2609`	`2611`	`type: 'origin',`
`2610`	`2612`	value: `E'${n.join('')}'`