@florajs/sql-parser

Parse simple SQL statements into an abstract syntax tree (AST) and convert it back to SQL.

Usage

Create AST for SQL statement

const{ Parser }=require('@florajs/sql-parser');constparser=newParser();constast=parser.parse('SELECT * FROM t');console.log(ast);

Convert AST back to SQL

const{ Parser }=require('@florajs/sql-parser');constast=(newParser()).parse('SELECT * FROM t');consttoSQL=require('@florajs/sql-parser').util.astToSQL;console.log(toSQL(ast));

The generated SQL is ANSI SQL compliant. To run those queries on MySQL, make sure you set correct SQL mode

SET SESSION sql_mode ='ANSI';

before running any query.

Acknowledgement

This project is based on the SQL parser extracted from Alibaba's nquery module.

License

GPL-2.0