@nore/nql

An extensible SQL query builder for SQLite.

Usage no npm install needed!

<script type="module">
  import noreNql from 'https://cdn.skypack.dev/@nore/nql';
</script>

README

@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/nql

Documentation

TODO: add documentation link

License MIT  ·  GitHub @nore  ·  Twitter @navaru