Parse simple SQL statements into an abstract syntax tree (AST) and convert it back to SQL.
var Parser = require('flora-sql-parser').Parser;
var parser = new Parser();
var ast = parser.parse('SELECT * FROM t');
console.log(ast);var Parser = require('flora-sql-parser').Parser;
var ast = (new Parser()).parse('SELECT * FROM t');
var toSQL = require('flora-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.