msql
JSON →msql is a lightweight JavaScript library for programmatically building SQL query strings (SELECT, INSERT, UPDATE, DELETE) without raw string concatenation, reducing SQL injection risk. Version 1.0.3 is the latest stable release. It supports a fluent API with methods like .where(), .field(), .config() for primary key assignment, enabling chainable query construction. Unlike ORMs, msql outputs raw SQL strings and targets Node.js with CommonJS only (no ESM). It is suitable for simple projects needing dynamic SQL generation, but lacks async support, prepared statements, and broader SQL dialect coverage.
Resources
packagemsql ↗