{"library":"named-placeholders","title":"named-placeholders","description":"Compiles SQL queries with named placeholders (:name) to unnamed positional parameterized queries (?) with a separate array of values. Version 1.1.7 (April 2026) is current; maintained under mysqljs organization on GitHub. Key differentiator: lightweight, zero-dependency solution for converting named placeholders in SQL strings for use with mysql/mysql2 or any ?-based driver. Handles nested quotes and escape sequences properly. Active development with frequent bug fixes.","language":"javascript","status":"active","last_verified":"Fri May 01","install":{"commands":["npm install named-placeholders"],"cli":null},"imports":["import toUnnamed from 'named-placeholders'","const compile = toUnnamed(); const [sql, params] = compile('SELECT :id', { id: 1 })","import { namedToUnnamed } from 'named-placeholders'; const q = namedToUnnamed('...', [])"],"auth":{"required":false,"env_vars":[]},"quickstart":{"code":"import toUnnamed from 'named-placeholders';\n\nconst compile = toUnnamed();\nconst [sql, params] = compile(\n  'SELECT * FROM users WHERE id = :id AND name = :name',\n  { id: 1, name: 'Alice' }\n);\nconsole.log(sql);   // 'SELECT * FROM users WHERE id = ? AND name = ?'\nconsole.log(params); // [1, 'Alice']\n\n// Also works with MySQL2:\n// const mysql = require('mysql2');\n// const connection = mysql.createConnection({ /* ... */ });\n// connection.execute(sql, params);","lang":"typescript","description":"Shows basic usage: import factory, call it to get compiler, invoke with query and parameters object, then use resulting array with mysql/mysql2.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}