npmpackage.info

Gathering detailed insights and metrics for node-sqlparser

Other packages similar to node-sqlparser

node-red-contrib-sqlparser

0.0.7

Parse SQL to JSON

Gathering detailed insights and metrics for node-sqlparser

node-sqlparser - 1.0.4 | npmpackage.info

node-sqlparser

Generic SQL engine for Web and Big-data.

1.0.4

383

JavaScript

10.28 kB

894,787 3

Installations

npm install node-sqlparser

Developer Guide

BETA

Typescript

No

Module System

CommonJS

Min. Node Version

>=0.8.0

Node Version

8.9.0

NPM Version

5.5.1 Score

80.9

Supply Chain

88.6

Quality

75.4

Maintenance

100

Vulnerability

80.9

License

Pull Requests

Open

0

Total

9

Closed

2

Merged

7

Issues

Open

12

Total

14

Closed

2

Releases

Unable to fetch releases

Languages

JavaScript

Makefile

JavaScript (99.87%)

Makefile (0.13%)

Developer

alibaba

Download Statistics

Total Downloads

894,787

Last Day

204

Last Week

1,810

Last Month

7,188

Last Year

307,702

GitHub Statistics

383 Stars

21 Commits

118 Forks

46 Watchers

2 Branches

10 Contributors

Updated on Jan 13, 2025

Bundle Size

47.39 kB

Minified

10.28 kB

Minified + Gzipped

Bundlephobia

Maintainers

View All 10 Contributors

Package Meta Information

Latest Version

1.0.4

Package Id

node-sqlparser@1.0.4

Size

29.25 kB

NPM Version

5.5.1

Node Version

8.9.0

Published on

Jul 12, 2018

Total Downloads

Cumulative downloads

Total Downloads

894,787

Last Day

30.8%

204

Compared to previous day

Last Week

0.8%

1,810

Compared to previous week

Last Month

-3.1%

7,188

Compared to previous month

Last Year

223%

307,702

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dev Dependencies

pegjs mocha should

node-sqlparser

======

node-sqlparser, write in javascript

Install

NodeJS Version 0.8.0+

npm install node-sqlparser

Introduction

for the test , type the command:

make test

Usage

static function

1var sql = 'select * from tablea where field1 = 0';
2var parse = require('node-sqlparser').parse;
3var stringify = require('node-sqlparser').stringify;
4var astObj = parse(sql);
5
6var sqlstr = stringify(astObj);

using ast

var AST = require('node-sqlparser');

var ast = new AST();
ast.parse(sql);

ast.stringify();

Acknowledgements

PegJS : http://pegjs.majda.cz/
NodeJS : http://nodejs.org/
BigQuery : https://developers.google.com/bigquery/docs/query-reference
PL/SQL : http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/fundamentals.htm#autoId0
MySQL : http://dev.mysql.com/doc/refman/5.1/en/sql-syntax.html
Impala : https://github.com/cloudera/impala/blob/master/fe/src/main/cup/sql-parser.y
PgSQL : http://www.postgresql.org/docs/9.2/interactive/sql-syntax.html
ql.io : http://ql.io

No vulnerabilities found.

10

Binary-Artifacts

Determines if the project has generated executable (binary) artifacts in the source repository.

10

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

3

Code-Review

Determines if the project requires human code review before pull requests (aka merge requests) are merged.

0

Maintained

Determines if the project is "actively maintained".

0

CII-Best-Practices

Determines if the project has an OpenSSF (formerly CII) Best Practices Badge.

0

Security-Policy

Determines if the project has published a security policy.

0

License

Determines if the project has defined a license.

0

Fuzzing

Determines if the project uses fuzzing.

0

Branch-Protection

Determines if the default and release branches are protected with GitHub's branch protection settings.

0

SAST

Determines if the project uses static code analysis.

Score

3

/10

Last Scanned on 2025-06-30

The Open Source Security Foundation is a cross-industry collaboration to improve the security of open source software (OSS). The Scorecard provides security health metrics for open source projects.

Learn More