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 | References | 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: ['*'],        // SELECT *
  FROM: ['revenue']     // FROM revenue
}))                     //

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

See for example the following example JSON and its corresponding SQL.

{
  "SELECT": [
    { "COUNT": "*", "AS": "num" }
  ],
  "FROM": [
    {
      "SELECT": ["*"],
      "FROM": ["mytable"],
      "WHERE": [
        "yyyymmdd", { "=": 20170101 },
        { "AND": [ "country", { "IN": ["IT", "US"] } ] },
        { "AND": [
          "categoryid", { "BETWEEN": [100, 200] },
          { "OR": [ "productname", { "!=": "icecream" } ] }
        ] }
      ]
    }
  ]
}

SELECT COUNT(*) AS num
FROM (
    SELECT *
    FROM mytable
    WHERE yyyymmdd = 20170101
        AND country IN ( 'IT', 'US' )
        AND (
            categoryid BETWEEN 100 AND 200
            OR productname != 'icecream'
        )
)

References

sql1992.txt was downloaded from http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt

License

MIT