node-sql (node-sql-2)

node-sql is a SQL query builder for Node.js that supports PostgreSQL, MySQL, Microsoft SQL Server, Oracle, and SQLite dialects. Current stable version is 0.80.1, maintained primarily by TokyoFarmer. It provides a fluent API to define tables and construct parameterized queries, making it composable and dialect-aware. Key differentiators include automatic parameterization, named queries, and a flexible join system. Unlike ORMs, it focuses purely on SQL generation without abstraction over database drivers. The package ships TypeScript type definitions.