Js-tsql-parser NPM

js-tsql-parser

WIP Adding support for TSQL, forked from JavaScriptor/js-sql-parser

parse / stringify sql (select grammar) in js.

sql grammar follows https://dev.mysql.com/doc/refman/5.7/en/select.html

commonjs usage

npm install --save js-tsql-parser

const parser = require('js-tsql-parser');
const ast = parser.parse('select * from dual');

console.log(JSON.stringify(ast, null, 2));

ast.value.selectItems.value[0].value = 'foo';
ast.value.from.value[0].value.value.value = 'bar';

console.log(parser.stringify(ast));
// SELECT foo FROM bar

script tag

<script src="./dist/parser/tsqlParser.js"><script/>

var tsqlParser = window.tsqlParser;
var ast = tsqlParser.parse('select * from dual');
var sql = tsqlParser.stringify(ast);