Licence
MIT
Version
2.2.0
Deps
1
Size
47 kB
Vulns
0
Weekly
0
@nore/nql
An extensible SQL query builder for SQLite.
import nql form "@nore/nql"
const query = {
type: "select",
table: "users",
columns: ["company", "category"],
where: {
company: "Future Inc"
age: { $gt: 25 },
},
offset: 200,
limit: 100,
}
const [sql, values] = nql(query)
// sql -> `SELECT "users"."name", "users"."age" FROM "users" WHERE "age" > $1 AND "company" == $2`
// values -> [25, "Future Inc"]Installation
$ npm install @nore/nqlDocumentation
TODO: add documentation link