node-sql-parser - npm Package Compare versions

Comparing version 3.8.4 to 3.9.0

ast/postgresql.ts

@@ -10,3 +10,3 @@
 
-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;
 
@@ -452,2 +452,9 @@ export type create_stmt = create_table_stmt | create_constraint_trigger | create_extension_stmt | create_index_stmt | create_sequence | create_db_stmt;
 
+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  {
@@ -491,3 +498,3 @@ parentheses_symbol: true;
 
-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; };
 
@@ -553,3 +560,3 @@
 
-export type where_clause = expr;
+export type where_clause = binary_expr;
 
@@ -663,7 +670,14 @@
 
+
+
 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)[];
         };
@@ -704,4 +718,2 @@
 
-export type parentheses_or_expr = binary_expr | or_expr;
-
 export type or_expr = binary_expr;
@@ -759,5 +771,7 @@
 
+export type string_constants_escape = { type: 'origin'; value: string; };
 
 
-export type column_ref = {
+
+export type column_ref = string_constants_escape | {
         type: 'column_ref';
@@ -764,0 +778,0 @@ table: ident;

lib/column.js

@@ -45,3 +45,4 @@ (function (global, factory) {
       parentheses,
-      property
+      property,
+      suffix
     } = expr;
@@ -52,2 +53,3 @@ let str = column === '*' ? '*' : columnOffsetToSQL(column, isDual);
     if (collate) result.push((0, _util.commonTypeValue)(collate).join(' '));
+    result.push((0, _util.toUpper)(suffix));
     const sql = result.filter(_util.hasVal).join(' ');
@@ -54,0 +56,0 @@ return parentheses ? `(${sql})` : sql;

lib/expr.js

@@ -30,3 +30,2 @@ (function (global, factory) {
     assign: _assign.assignToSQL,
-    extract: _func.extractFunToSQL,
     binary_expr: _binary.binaryToSQL,
@@ -36,2 +35,3 @@ case: _case.caseToSQL,
     column_ref: _column.columnRefToSQL,
+    extract: _func.extractFunToSQL,
     function: _func.funcToSQL,
@@ -38,0 +38,0 @@ interval: _interval.intervalToSQL,

lib/update.js

@@ -34,4 +34,3 @@ (function (global, factory) {
         column,
-        value,
-        keyword
+        value
       } = set;
@@ -47,3 +46,2 @@ const str = [table, column].filter(_util.hasVal).map(info => (0, _util.identifierToSql)(info)).join('.');
 
-      if (keyword) setItem[2] = `${(0, _util.toUpper)(keyword)}(${val})`;
       clauses.push(setItem.filter(_util.hasVal).join(' '));
@@ -50,0 +48,0 @@ }

package.json

 {
   "name": "node-sql-parser",
-  "version": "3.8.4",
+  "version": "3.9.0",
   "description": "simple node sql parser",
@@ -5,0 +5,0 @@ "main": "index.js",

No alert changes

Improved metrics

Total package byte prevSize

38825091

increased by0.36%

Lines of code

22620

increased by0.22%

Worsened metrics

Number of package files

94

decreased by-1.05%

No dependency changes