0.10.1 • Published 2 years ago
qh-flora-sql-parser v0.10.1
Flora 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('flora-sql-parser').Parser;
const parser = new Parser();
const ast = parser.parse('SELECT * FROM t');
console.log(ast);
Convert AST back to SQL:
const Parser = require('flora-sql-parser').Parser;
const ast = (new Parser()).parse('SELECT * FROM t');
const 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.
Acknowledgement
This project is based on the SQL parser extracted from Alibaba's nquery module.
License
0.10.1
2 years ago
0.9.3
4 years ago
0.9.2
4 years ago
0.9.1
4 years ago
0.8.1
4 years ago
0.7.22
4 years ago
0.7.21
6 years ago
0.7.20
6 years ago
0.7.19
6 years ago
0.7.18
6 years ago
0.7.17
6 years ago
0.7.16
6 years ago
0.7.15
6 years ago
0.7.14
6 years ago
0.7.13
6 years ago
0.7.12
6 years ago
0.7.11
6 years ago
0.7.10
6 years ago
0.7.9
6 years ago
0.7.8
6 years ago
0.7.7
6 years ago
0.7.6
7 years ago
0.7.5
7 years ago
0.7.4-1
7 years ago