node-sql-parser

A SQL parser for Node.js that converts SQL statements into an abstract syntax tree (AST) and back. Version 1.8.31 supports SELECT, DELETE, UPDATE, INSERT, DROP, TRUNCATE, and RENAME commands. It can handle multiple SQL statements separated by semicolons and outputs tables and columns visited. Supports MySQL, PostgreSQL, Hive, MariaDB, and TransactSQL dialects. Ships with TypeScript definitions. The parser is designed for simple SQL parsing needs and allows opting into TypeScript types via definitely typed.