node-sql-parser - npm Package Compare versions

Comparing version 5.3.4 to 5.3.5

ast/postgresql.ts

@@ -205,5 +205,8 @@
 
+export type include_column = { type: 'include', keyword: 'include', columns: column_list };
+
 export interface create_index_stmt_node {
       type: 'create';
       index_type?: 'unique';
+      if_not_exists: if_not_exists_stmt;
       keyword: 'index';
@@ -216,2 +219,3 @@ concurrently?: 'concurrently';
       index_columns: column_order[];
+      include?: column_list_items;
       with?: index_option[];
@@ -418,3 +422,3 @@ with_before_where: true;
         resource: 'column';
-        if_not_exists: ife;
+        if_not_exists: if_not_exists_stmt;
         type: 'alter';
@@ -862,4 +866,6 @@ } & create_column_definition;;
 
-export type select_stmt = { type: 'select'; } | select_stmt_nake | select_stmt_node;
+export type select_stmt_parentheses = select_stmt_node;
 
+export type select_stmt = { type: 'select'; } | select_stmt_nake | select_stmt_parentheses;
+
 export type with_clause = cte_definition[] | [cte_definition & { recursive: true; }];
@@ -907,3 +913,3 @@
 
-export type column_item_suffix = [{ type: 'origin'; value: string; }, quoted_ident_type];
+export type column_item_suffix = [{ type: 'origin'; value: string; }, quoted_ident_type | column_ref];
 
@@ -910,0 +916,0 @@ export type column_list_item = { expr: expr; as: null; } | { type: 'cast'; expr: expr; symbol: '::'; target: cast_data_type;  as?: null; } | { expr: column_ref; as: null; } | { type: 'expr'; expr: expr; as?: alias_clause; };

lib/alter.js

@@ -72,3 +72,6 @@ (function (global, factory) {
     }
-    const alterArray = [(0, _util.toUpper)(action), (0, _util.toUpper)(keyword), (0, _util.toUpper)(ifNotExists), (0, _util.toUpper)(ifExists), oldColumn && (0, _column.columnRefToSQL)(oldColumn), (0, _util.toUpper)(prefix), name && name.trim(), dataType.filter(_util.hasVal).join(' '), suffix && `${(0, _util.toUpper)(suffix.keyword)} ${(0, _column.columnRefToSQL)(suffix.expr)}`];
+    const alterArray = [(0, _util.toUpper)(action), (0, _util.toUpper)(keyword), (0, _util.toUpper)(ifNotExists), (0, _util.toUpper)(ifExists), oldColumn && (0, _column.columnRefToSQL)(oldColumn), (0, _util.toUpper)(prefix), name && name.trim(), dataType.filter(_util.hasVal).join(' ')];
+    if (suffix) {
+      alterArray.push((0, _util.toUpper)(suffix.keyword), suffix.expr && (0, _column.columnRefToSQL)(suffix.expr));
+    }
     return alterArray.filter(_util.hasVal).join(' ');
@@ -75,0 +78,0 @@ }

lib/create.js

@@ -210,3 +210,3 @@ (function (global, factory) {
     const withIndexOpt = withExpr && `WITH (${(0, _indexDefinition.indexOptionListToSQL)(withExpr).join(', ')})`;
-    const includeColumns = include && `${(0, _util.toUpper)(include.keyword)} (${include.columns.map(col => (0, _util.identifierToSql)(col)).join(', ')})`;
+    const includeColumns = include && `${(0, _util.toUpper)(include.keyword)} (${include.columns.map(col => typeof col === 'string' ? (0, _util.identifierToSql)(col) : (0, _expr.exprToSQL)(col)).join(', ')})`;
     let indexName = index;
@@ -213,0 +213,0 @@ if (index) {

package.json

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

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

89216520

increased by0.13%

Lines of code

50975

increased by0.11%

No dependency changes