qh-flora-sql-parser

0.10.1 • Public • Published

Flora SQL Parser

Build Status NPM version Dependencies

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

MIT

Readme

Keywords

Package Sidebar

Install

npm i qh-flora-sql-parser

Weekly Downloads

2

Version

0.10.1

License

MIT

Unpacked Size

348 kB

Total Files

16

Last publish

Collaborators

  • noteon