node-sql-parser

A SQL parser for Node.js that converts SQL statements into an abstract syntax tree (AST) and back. Version 5.3.27 supports multiple dialects including MySQL, PostgreSQL, SQLite, BigQuery, and others. It outputs visited table and column lists with authority information. Released monthly, it supports SELECT, INSERT, UPDATE, DELETE, DROP, TRUNCATE, and RENAME commands. Differentiators: provides both AST and table/column lists, supports multiple databases, and is available as a UMD bundle for browsers. Ships TypeScript types.