yesql

A Node.js library for reading named SQL statements from .sql files and using named parameters in prepared statements. Version 7.0.0 supports PostgreSQL, MySQL/MariaDB, and raw/SQLite drivers. It parses SQL files with named queries and converts named parameters (e.g. :name, $name) into database-specific parameterized formats. Key differentiator: it handles multiple database dialects, supports quoted strings, missing parameter handling, and throws on duplicate query names. Released on npm, maintained, with active development history.