{"id":43840,"library":"simple-sql-parser","title":"simple-sql-parser","description":"A JavaScript library for parsing CRUD (Create, Retrieve, Update, Delete) SQL queries into an AST. Currently at version 2.0.0-alpha.1 with sporadic maintenance. Supports basic SELECT, INSERT, UPDATE, DELETE statements. Limited documentation and unmaintained since 2014; alternative libraries like 'sql-parser' or 'node-sql-parser' are more robust. For legacy projects only.","status":"abandoned","version":"2.0.0-alpha.1","language":"javascript","source_language":"en","source_url":"https://github.com/dsferruzza/simpleSqlParser","tags":["javascript","sql","parse","ast"],"install":[{"cmd":"npm install simple-sql-parser","lang":"bash","label":"npm"},{"cmd":"yarn add simple-sql-parser","lang":"bash","label":"yarn"},{"cmd":"pnpm add simple-sql-parser","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"Function export is named; no default export.","wrong":"import parse from 'simple-sql-parser';","symbol":"parse","correct":"import { parse } from 'simple-sql-parser';"},{"note":"CommonJS require works, but type definition may be missing.","wrong":"const { SqlQuery } = require('simple-sql-parser');","symbol":"SqlQuery","correct":"import { SqlQuery } from 'simple-sql-parser';"},{"note":"SqlNode is an interface for TypeScript users; prefer type import.","wrong":"import { SqlNode } from 'simple-sql-parser';","symbol":"SqlNode","correct":"import type { SqlNode } from 'simple-sql-parser';"}],"quickstart":{"code":"import { parse } from 'simple-sql-parser';\n\nconst query = 'SELECT id, name FROM users WHERE age > 18 ORDER BY name DESC';\nconst ast = parse(query);\nconsole.log(JSON.stringify(ast, null, 2));\n// Output includes: type, columns, from, where, order","lang":"typescript","description":"Parses a SELECT SQL query into an AST structure showing columns, tables, where clause, and ordering."},"warnings":[{"fix":"Migrate to actively maintained alternatives like node-sql-parser.","message":"simple-sql-parser is abandoned; last release in 2014 and repository archived.","severity":"deprecated","affected_versions":">=1.0.0"},{"fix":"Pre-validate SQL or use a more comprehensive parser.","message":"The library only supports basic CRUD; JOIN, subqueries, and complex expressions may throw errors.","severity":"gotcha","affected_versions":">=0.0.1"},{"fix":"Check source code on GitHub for API usage.","message":"Version 2.0.0-alpha.1 has breaking API changes from v1 but no documentation.","severity":"breaking","affected_versions":"2.0.0-alpha.1"},{"fix":"Define own interfaces or use a parser with built-in types.","message":"No TypeScript type definitions bundled; types must be manually written.","severity":"gotcha","affected_versions":"*"}],"env_vars":null,"search_vec":"'2.0.0':23 '2014':40 'alpha.1':24 'altern':41 'ast':19,62 'basic':29 'creat':11 'crud':10 'current':20 'delet':14,33 'document':36 'insert':31 'javascript':6,59 'legaci':56 'librari':7,42 'like':43 'limit':35 'mainten':27 'node':49 'node-sql-pars':48 'pars':9,61 'parser':4,46,51 'project':57 'queri':16 'retriev':12 'robust':54 'select':30 'simpl':2 'simple-sql-pars':1 'sinc':39 'sporad':26 'sql':3,15,45,50,60 'sql-parser':44 'statement':34 'support':28 'unmaintain':38 'updat':13,32 'version':22","created_at":"2026-06-05T17:01:43.895117+00:00","updated_at":"2026-06-05T17:01:43.895117+00:00","problems":[{"fix":"import { parse } from 'simple-sql-parser';","cause":"Using default import instead of named import.","error":"TypeError: parse is not a function"},{"fix":"npm install simple-sql-parser@2.0.0-alpha.1","cause":"Package not installed or path issue in Node.js.","error":"Cannot find module 'simple-sql-parser'"},{"fix":"Use a more complete SQL parser like 'node-sql-parser'.","cause":"Library does not support UNION queries.","error":"Error: Not implemented: UNION"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/dsferruzza/simpleSqlParser","github":"https://github.com/dsferruzza/simpleSqlParser","docs":null,"changelog":null,"pypi":null,"npm":"simple-sql-parser","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}