npmpackage.info

Gathering detailed insights and metrics for @nuage/sql-fmt

@nuage/sql-fmt - 1.0.4 | npmpackage.info

@nuage/sql-fmt

Simple SQL escape and format for MySQL \ Postgres and easy create Ojbect to SQL

1.0.4

MIT

JavaScript

1.84 kB

451 1.7

Installations

npm install @nuage/sql-fmt

Developer Guide

BETA

Typescript

Yes

Module System

CommonJS

Node Version

15.3.0

NPM Version

6.14.8 Score

Supply Chain

89.8

Quality

74.7

Maintenance

100

Vulnerability

100

License

Pull Requests

Open

0

Total

0

Closed

0

Issues

Open

0

Total

0

Closed

0

Releases

Unable to fetch releases

Languages

JavaScript

TypeScript

JavaScript (53.17%)

TypeScript (46.83%)

Developer

ymzuiku

Download Statistics

Total Downloads

451

Last Day

Last Week

Last Month

Last Year

GitHub Statistics

MIT License

1 Stars

22 Commits

1 Watchers

2 Branches

1 Contributors

Updated on Feb 19, 2021

Bundle Size

4.08 kB

Minified

1.84 kB

Minified + Gzipped

Bundlephobia

Maintainers

View All 1 Contributors

Package Meta Information

Latest Version

1.0.4

Package Id

@nuage/sql-fmt@1.0.4

Unpacked Size

13.08 kB

Size

4.38 kB

File Count

NPM Version

6.14.8

Node Version

15.3.0

Total Downloads

Cumulative downloads

Total Downloads

451

Last Day

-50%

Compared to previous day

Last Week

Compared to previous week

Last Month

22.2%

Compared to previous month

Last Year

-17%

Compared to previous year

Weekly Downloads

Monthly Downloads

Yearly Downloads

Dependencies

sqlutils

Dev Dependencies

rollup rollup-plugin-typescript2 rollup-plugin-uglify typescript

sql-fmt

Base by sqlstring and sqlutils

Simple SQL escape and format for MySQL \ Postgres and easy create Ojbect to SQL, support typescript.

sql.escape: Use sqlstring escape SQL string
sql.values: Format and escape JS { key : value } to SQL (key1, key2) VALUES (value1, value2)
sql.where: Format and escape JS { key : value } to SQL (key1='value1' AND key2='value2')
sql.set: Format and escape JS { key : value } to SQL key1='value1', key2='value2'

Install

1$ npm install sql-fmt

In javascript use MySQL

1const sql = require("sql-fmt"); // MySQL

or use Postgres

1const sql = require("sql-fmt/pg"); // Postgres

sql.escape

1console.log(`SELECT * FROM users WHERE name=${sql.escape("hello")};`);
2//out: SELECT * FROM users WHERE name='hello';
3
4console.log(`SELECT * FROM users WHERE name=${sql.escape("'hello' OR 1=1")}`);
5//out: SELECT * FROM users WHERE name='\'hello\' OR 1=1';

sql.values

1console.log(`INSERT INTO users ${sql.values({ dog: "ff", age: 20 })};`);
2//out: INSERT INTO users (dog,age) VALUES ('ff',20);
3
4console.log(
5  `INSERT INTO users ${sql.values([
6    { dog: "aa", age: 10 },
7    { dog: "bb", age: 20 },
8  ])};`
9);
10//out: INSERT INTO users (dog,age) VALUES ('aa',10),('bb',20);

sql.where

1console.log(`SELECT * FROM users WHERE ${sql.where({ dog: "ff", age: 20 })};`);
2//out: SELECT * FROM users WHERE (dog='ff' AND age=20);
3
4console.log(
5  `SELECT * FROM users WHERE ${sql.where({ dog: ["aa", "bb"], age: 20 })};`
6);
7//out: SELECT * FROM users WHERE ((dog='aa' OR dog='bb') AND age=20);

sql.set

1console.log(
2  `UPDATE users SET ${sql.set({ dog: "ff", age: 20 })} where ${sql.where({
3    name: "apple",
4  })};`
5);
6//out: UPDATE users SET dog='ff',age=20 where (name='apple');

No vulnerabilities found.

10

Binary-Artifacts

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

10

License

Determines if the project has defined a license.

0

SAST

Determines if the project uses static code analysis.

0

Maintained

Determines if the project is "actively maintained".

0

Code-Review

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

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

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

Vulnerabilities

Determines if the project has open, known unfixed vulnerabilities.

Score

1.7

/10

Last Scanned on 2025-04-28

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