js-tsql-parser
JavaScriptor/js-sql-parser
[WIP] Adding support for TSQL, forked fromparse / 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 = ;const ast = parser; console; astvalueselectItemsvalue0value = 'foo';astvaluefromvalue0valuevaluevalue = 'bar'; console;// SELECT foo FROM bar
script tag
<script src="./dist/parser/tsqlParser.js"><script/> var tsqlParser = windowtsqlParser;var ast = tsqlParser;var sql = tsqlParser;
AMD supported
...
unsupported grammar currently
- Hexadecimal Literals as x'01af' X'01af', but 0x01af is supported.
- keyword COLLATE.
- parammarker: keyword PREPARE / EXECUTE / DEALLOCATE
- variable: keyword SET / CREATE PROCEDURE / CREATE FUNCTION
- identifier expr: ODBC escape syntax
- matchexpr: Full-Text Search Functions. // to support
- intervalexpr: Date INTERVAL keyword. // to support
- into outfile: INTO OUTFILE keyword. // to support
TODO
- ${value} like value place holder support.
Build
- Run
npm run build
to build the distributable.
LICENSE
MIT