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

13.08 kB

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 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

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

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

NaN

Last Day

NaN

Compared to previous day

Last Week

NaN

Compared to previous week

Last Month

NaN

Compared to previous month

Last Year

NaN

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-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