# @nore/nql

> An extensible SQL query builder for SQLite

Latest version **2.2.0** (published 2020-03-08) · MIT license · 0 weekly downloads

## Install

```sh
npm install @nore/nql
pnpm add @nore/nql
yarn add @nore/nql
bun add @nore/nql
```

## Health

**Score 20/100 (F)** — status: abandoned.

Positive: esm support; no vulnerabilities.

Warnings: low downloads; no types.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 2.2.0 |
| Published | 2020-03-08 |
| First published | 2018-11-13 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | ESM + CommonJS |
| Node | >=13 |
| Dependencies | 1 |
| Unpacked size | 46.7 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Author | Navaru |
| Maintainers | nore |

## Links

- npm: https://www.npmjs.com/package/@nore/nql
- Repository: https://github.com/nore/nql
- Homepage: https://github.com/nore/nql#readme
- Issues: https://github.com/nore/nql/issues
- npm.io page: https://npm.io/package/@nore/nql

## Dependencies (1)

- [@nore/std](https://npm.io/package/@nore/std.md) ^1.11.0

## Recent versions

- 2.2.0 (latest) — 2020-03-08
- 2.1.0 — 2019-11-12
- 2.0.0 — 2019-02-04
- 1.3.1 — 2019-01-28
- 1.3.0 — 2019-01-25
- 1.2.2 — 2019-01-22
- 1.2.1 — 2019-01-22
- 1.2.0 — 2019-01-22
- 1.1.0 — 2019-01-22
- 1.0.0 — 2018-11-13

## README

# @nore/nql

An extensible SQL query builder for SQLite.

```js
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/nql
```

**Documentation**

TODO: add documentation link

---

> License [MIT](license)  · 
> GitHub [@nore](https://github.com/nore)  · 
> Twitter [@navaru](https://twitter.com/navaru)

---
_Source: https://npm.io/package/@nore/nql · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._