@nuage/sql-fmt

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

Usage no npm install needed!

<script type="module">
  import nuageSqlFmt from 'https://cdn.skypack.dev/@nuage/sql-fmt';
</script>

README

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

$ npm install sql-fmt

In javascript use MySQL

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

or use Postgres

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

sql.escape

console.log(`SELECT * FROM users WHERE name=${sql.escape("hello")};`);
//out: SELECT * FROM users WHERE name='hello';

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

sql.values

console.log(`INSERT INTO users ${sql.values({ dog: "ff", age: 20 })};`);
//out: INSERT INTO users (dog,age) VALUES ('ff',20);

console.log(
  `INSERT INTO users ${sql.values([
    { dog: "aa", age: 10 },
    { dog: "bb", age: 20 },
  ])};`
);
//out: INSERT INTO users (dog,age) VALUES ('aa',10),('bb',20);

sql.where

console.log(`SELECT * FROM users WHERE ${sql.where({ dog: "ff", age: 20 })};`);
//out: SELECT * FROM users WHERE (dog='ff' AND age=20);

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

sql.set

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