pg-builder

1.0.2 • Public • Published

pg-builder

PostgreSQL query builder

Build Status

Installation

npm install pg-builder

Usage

var q = require('pg-builder')()
.select('user_id', 'username')
.select('age')
.from('users')
.where('age >= ${minAge}')
.order('username', 'asc')
.limit(500)
.param('minAge', 27)
 
console.log(q.text)
console.log(q.values)
 
/*
SELECT user_id, username, age
FROM users
WHERE age >= $1
ORDER BY username
LIMIT 500
[ 27 ]
*/

See tests for more

Package Sidebar

Install

npm i pg-builder

Weekly Downloads

16

Version

1.0.2

License

MIT

Last publish

Collaborators

  • abrkn