js-sql-parser

parse sql (select grammar) in js.

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

TODO

• ${value} like value place holder support.
• benchmark

unsupport 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

commonjs usage

npm install --save js-sql-parser

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

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

script tag

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

var sqlParser = window.sqlParser;
sqlParser.parse('select * from dual');

AMD support

...