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 and viceversa parse an SQL and serialize it into a JSON

🚧 STATUS: Right now the test suite contains 34 SELECT statements (and 1 CREATE) that are serialized into JSON and viceversa parsed back into SQL successfully. Adding INSERT and other DMLs statementes as well as DDLs is on the roadmap.

Installation

With npm do

npm install sql92-json

API

`stringify`

Convert a JSON to SQL

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

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

`parse`

Convert an SQL to JSON

var sql2json = require('sql92-json').parse

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

Recipes

Spool header

Examples

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