{"library":"sql-compiler","title":"sql-compiler","type":"library","description":"A SQL compiler library for Node.js (version 1.0.2, latest) that tokenizes, parses, and generates SQL, allowing dynamic editing of the query AST. Releases are infrequent (no recent updates). Differentiators: provides a full pipeline (tokenizer, parser, code generator) and a manipulable AST, unlike pure SQL parsers. Requires Node >=15 (ESM-only). Not widely adopted; use with caution for production.","language":"javascript","status":"active","last_verified":"Fri May 01","install":{"commands":["npm install sql-compiler"],"cli":null},"imports":["import tokenizer from 'sql-compiler/modules/tokenizer.mjs'","import parser from 'sql-compiler/modules/parser/parser.mjs'","import codeGenerator from 'sql-compiler/modules/code-generator.mjs'"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":null,"github":"https://github.com/leoelias023/sql-compiler","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/sql-compiler","openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import tokenizer from 'sql-compiler/modules/tokenizer.mjs';\nimport parser from 'sql-compiler/modules/parser/parser.mjs';\nimport codeGenerator from 'sql-compiler/modules/code-generator.mjs';\n\nconst sql = `SELECT 'Leonardo' AS name, 'Dicaprio' AS lastname FROM dual l`;\nconst tokens = tokenizer(sql);\nconst { value: ast } = parser(tokens);\nast.value.columns.push({ type: 'NUMERIC', value: '20', alias: 'age' });\nconst updatedSql = codeGenerator(ast);\nconsole.log(updatedSql);\n// Output: SELECT 'Leonardo' AS name, 'Dicaprio' AS lastname, 20 AS age FROM dual l","lang":"javascript","description":"Parses a SQL SELECT query, manipulates the AST to add a column, and generates the updated SQL string.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}