named-placeholders

sql named placeholders to unnamed compiler

MIT 11 个版本
sql pdo named placeholders mysql postgres
主页
仓库
提交 Issue
安装
npm install named-placeholders
yarn add named-placeholders
pnpm add named-placeholders
bun add named-placeholders
README

NPM

CI

named-placeholders

compiles "select foo where foo.id = :bar and foo.baz < :baz" into "select foo where foo.id = ? and foo.baz < ?" + ["bar", "baz"]

usage

npm install named-placeholders

see this mysql2 discussion

var mysql = require('mysql');
var toUnnamed = require('named-placeholders')();

var q = toUnnamed('select 1+:test', { test: 123 });
mysql.createConnection().query(q[0], q[1]);

credits

parser is based on @mscdex code of his excellent node-mariasql library

版本列表
1.1.6 2025-12-15
1.1.4 2025-12-08
1.1.3 2023-01-12
1.1.2 2018-11-07
1.1.1 2015-11-25
1.1.0 2015-09-21
1.0.0 2015-09-14
0.1.3 2015-01-09
0.1.2 2015-01-09
0.1.1 2014-08-30
0.1.0 2014-08-30