open-index/open-npm huggingface dataset:
npm package: @sqlw/file-async-ts
Description: ``@sqlw/file-async-ts` is a typescript library applying the facade pattern to asynchronous file access.
Author: Eric Hosick
Latest version: 2.0.1
Deprecated: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

# **@sqlw/file-async-ts**

`@sqlw/file-async-ts` has moved to [@sqlpm/file-async-ts](https://www.npmjs.com/package/@sqlpm/file-async-ts).
npm package: @sqlw/parse-json-ts
Description: `pares-json-ts` is a typescript package that converts JSON text to a javascript object: optionally verifying and casting the object type.
Author: Eric Hosick
Latest version: 2.0.0
Deprecated: Package no longer supported. Contact Support at https://www.npmjs.com/support for more info.

# **@sqlw/parse-json-ts**

`@sqlw/parse-json-ts` has moved to [@sqlpm/parse-json-ts](https://www.npmjs.com/package/@sqlpm/parse-json-ts).
npm package: @sqorn/pg
Description: A Javascript library for building Postgres queries
Author: Sufyan Dawoodjee
Latest version: 0.0.45

# [<img src="https://raw.githubusercontent.com/sqorn/sqorn/master/docs/website/static/img/logo_blue.svg?sanitize=true" height="38px"/> <span style="color: #2979f">Sqorn Postgres</span>](https://sqorn.org) &middot; [![License](https://img.shields.io/github/license/sqorn/sqorn.svg)](https://github.com/sqorn/sqorn/blob/master/LICENSE) [![npm](https://img.shields.io/npm/v/sqorn.svg)](https://www.npmjs.com/package/sqorn-pg) ![Supports Node 8+](https://img.shields.io/node/v/sqorn-pg.svg) [![npm](https://img.shields.io/travis/sqorn/sqorn.svg)](https://travis-ci.org/sqorn/sqorn)

Sqorn Postgres is a Javascript library for building SQL queries.

**Composable:** Build complex queries from simple parts. Chain, extend, and embed queries.

**Intuitive**: Sqorn's use of modern Javascript language features like tagged template literals and promises makes building and issuing SQL queries a breeze.

**Concise:** Sqorn provides concise syntax for common CRUD operations.

[**Fast:**](https://sqorn.org/benchmarks.html) 10x faster than [Knex.js](https://knexjs.org/) and 200x faster than [Squel](https://github.com/hiddentao/squel)

**Secure:** Sqorn generates parameterized queries safe from SQL injection. Sqorn has no external dependencies.

## Install

Sqorn requires Node version 8 or above.

```sh
npm install --save @sqorn/pg # only Postgres is currently supported
```

Then read the [tutorial](https://sqorn.org/docs/tutorial.html) and [try the online demo](https://sqorn.org/demo.html).

## Examples

CRUD Operations are dead simple.

```js
const sq = require('@sqorn/pg')()

const Person = sq`person`, Book = sq`book`

// SELECT
const children = await Person`age < ${13}`
// "select * from person where age < 13"

// DELETE
const [deleted] = await Book.delete({ id: 7 })`title`
// "delete from book where id = 7 returning title"

// INSERT
await Person.insert({ firstName: 'Rob' })
// "insert into person (first_name) values ('Rob')"

// UPDATE
await Person({ id: 23 }).set({ name: 'Rob' })
// "update person set name = 'Rob' where id = 23"

```

Build complex queries from simple parts.

```js
// CHAIN QUERIES
sq.from`book`
  .return`distinct author`
  .where({ genre: 'Fantasy' })
  .where({ language: 'French' })
// select distinct author from book
// where language = 'French' and genre = 'Fantasy'

// EXTEND QUERIES
sq.extend(
  sq.from`book`,
  sq.return`distinct author`,
  sq.where({ genre: 'Fantasy' }),
  sq.where({ language: 'French' })
)
// select distinct author from book
// where language = 'French' and genre = 'Fantasy'

// EMBED Queries
sq.return`now() today, (${sq.return`now() + '1 day'`}) tomorrow`
// select now() today, (select now() + '1 day') tomorrow
```

Learn more in the [tutorial](https://sqorn.org/docs/tutorial.html).

## License

MIT Licensed, Copyright (c) 2018 Sufyan Dawoodjee