
gittech. site
for different kinds of informations and explorations.
2500 lines just to parse a CREATE TABLE statement
Published at
Jan 19, 2025
Main Article
oracle-sql-parser
Simple SQL parser and AST explorer for Oracle SQL following the Oracle Database Language Reference.
Usage
Install the package:
npm i oracle-sql-parser
Parse and print:
const { Parser } = require('oracle-sql-parser');
const parser = new Parser();
const sql = 'CREATE TABLE users (id integer);';
const ast = parser.parse(sql);
console.log(ast);
Run locally
git clone https://github.com/1ilit/oracle-sql-parser.git
cd oracle-sql-parser
npm i
npm test
Scripts
Generate the parser in ./build/parser.js
npm run generate
Generate and minify the parser in ./build/parser.js
npm run build