Package Exports

sql92-json

This package does not declare an exports field, so the exports above have been automatically detected and optimized by JSPM instead. If any package subpath is missing, it is recommended to post an issue to the original package (sql92-json) to support the "exports" field. If that is not possible, create a JSPM override to customize the exports field for this package.

Readme

SQL92-JSON

can stringify a JSON into an SQL

Installation | Usage | License

Installation

With npm do

npm install sql92-json

Usage

Convert a JSON to SQL

var json2sql = require('sql92-json').stringify

console.log(json2sql({SELECT: ['*'], FROM: ['revenue']}))
// SELECT *
// FROM revenue
//

See examples folder where every .json file has its homonym .sql.

See for example the following [example JSON][exampleJSON] and its corresponding SQL.

{
  "SELECT": ["*"],
  "FROM": ["mytable"],
  "WHERE": [
    "yyyymmdd", { "=": 20170101 },
    { "AND": [ "country", { "=": "IT" } ] }
  ]
}

SELECT *
FROM mytable
WHERE yyyymmdd = 20170101
    AND country = 'IT'

License

MIT