sql-named-params

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

npm install --save sql-named-params

Usage

import { convert } from 'sql-named-params';

const sql = 'SELECT heros WHERE lastName = :lastName AND age <= :age';
const params = {
  lastName: 'Skywalker',
  age: 30,
};
const { query, values } = convert(sql, params);

console.log(query);
// => 'SELECT heros WHERE lastName = ? AND age <= ?'

console.log(values);
// => ['Skywalker', 30]

Development

npm install
npm run build