puresql

puresql is a Node.js SQL library inspired by Clojure's yesql that lets you define SQL queries in .sql files with named parameters and modifiers, then loads them as async functions. The current stable version is 1.10.0. It supports MySQL, MariaDB, PostgreSQL, MS SQL Server, and SQLite via adapters. Unlike ORMs or query builders, puresql keeps SQL raw and separate from JS logic, and supports parameter modifiers for safe interpolation, object insertion/update, dynamic conditions, and conditional clauses. Ships TypeScript definitions. Requires Node >= 6.0.0. Maintained but infrequent releases.