sql-named-params

Convert SQL named parameters to placeholders and values.

Usage no npm install needed!

<script type="module">
  import sqlNamedParams from 'https://cdn.skypack.dev/sql-named-params';
</script>

README

NPM Version CI codecov Dependency Status Dev Dependency Status

SQL Named Parameters

Convert SQL named parameters to placeholders and values.

Table of Contents

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