{"library":"yesql","type":"library","category":null,"description":"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.","language":"javascript","status":"active","version":"7.0.0","tags":["javascript","sql","named","parameter","prepared","statement","pg","postgres","node-pg"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install yesql","imports":["const sql = require('yesql')('/path/to/sql', {type: 'pg'})","const named = require('yesql').mysql","const named = require('yesql').pg"]},{"cmd":"yarn add yesql","imports":[]},{"cmd":"pnpm add yesql","imports":[]}],"homepage":"https://github.com/pihvi/yesql#readme","github":"ssh://git@github.com/pihvi/yesql","docs":null,"changelog":null,"pypi":null,"npm":"yesql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}