SQL query builder
Construct queries to pass to node-postgres query().
This library uses sql-template-strings to build query statement objects.
import { createQuery } from 'querie'
const bluePeopleInsert = createQuery({
kind: 'insert',
table: 'people',
values: [
{ name: 'Chris', color: 'blue' },
{ name: 'Kevin', color: 'blue' }
]
})
// => insert into people (name, color) values ('Chris', 'blue'), ('Kevin', 'blue')
const bluePeopleSelect = createQuery({
kind: 'select',
table: 'people',
columns: ['name', 'age'],
where: {
color: ['=', 'blue']
}
})
// => select name, age from people where color = 'blue'
const bluePeopleUpdate = createQuery({
kind: 'update',
table: 'people',
set: {
color: 'green'
},
where: {
color: ['=', 'blue']
}
})
// => update people set color = 'green' where color = 'blue'-
State and side-effect free query building.
Queries are built without knowledge of or connection to a database. -
Data driven queries
Queries are built using plain JavaScript data structures, no method chaining. -
Column aliases
Alias JS friendly column names to what is in the database seamlessly.