SQL Named Parameters

Convert SQL named parameters to placeholders and values.

Table of Contents

• Features
• Installation
• Usage
• Development

Features

• 🚀 Zero dependencies, super tiny.
• 💪 Written in TypeScript.

Installation

1npm install --save sql-named-params

Usage

1import { convert } from 'sql-named-params';
2
3const sql = 'SELECT heros WHERE lastName = :lastName AND age <= :age';
4const params = {
5  lastName: 'Skywalker',
6  age: 30,
7};
8const { query, values } = convert(sql, params);
9
10console.log(query);
11// => 'SELECT heros WHERE lastName = ? AND age <= ?'
12
13console.log(values);
14// => ['Skywalker', 30]
15

Development

1npm install
2npm run build