sql-json-generator

sql-json-generator (v0.15.1) is a Node.js module that generates SQL queries (SELECT, INSERT, UPDATE, DELETE) from JSON objects, loosely based on MongoDB query syntax. It supports MySQL features like backtick escaping, aggregate functions, joins, subqueries via $raw, and SqlCalcFoundRows. The library is designed to simplify building reusable JSON query definitions for REST APIs with MySQL backends. It is not ESM-native and relies on CommonJS. Updates are infrequent; the last release was in 2021. Compared to alternatives like knex.js or sequelize, it is more lightweight but lacks ORM features and broader database support.