# squl

> A collection of SQL utility functions.

Latest version **1.0.0** (published 2019-07-15) · MIT license · 0 weekly downloads

> **Deprecated.** This package is deprecated.

## Install

```sh
npm install squl
pnpm add squl
yarn add squl
bun add squl
```

## Health

**Score 10/100 (F)** — status: deprecated.

Negative: deprecated.

## Facts

| | |
|---|---|
| Version | 1.0.0 |
| Published | 2019-07-15 |
| First published | 2019-07-15 |
| Weekly downloads | 0 |
| License | MIT |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 0 |
| Unpacked size | 3.9 KB |
| Known vulnerabilities | 0 |
| Install scripts | no |
| Author | Sergej Sintschilin |
| Maintainers | seregpie |
| Keywords | build, escape, help, list, mysql, query, sql, util |

## Links

- npm: https://www.npmjs.com/package/squl
- Repository: https://github.com/SeregPie/squl
- Homepage: https://github.com/SeregPie/squl#readme
- Issues: https://github.com/SeregPie/squl/issues
- npm.io page: https://npm.io/package/squl

## Alternatives

- [gamedig](https://npm.io/package/gamedig.md) — 29.3K weekly downloads
- [join-monster](https://npm.io/package/join-monster.md) — 12.8K weekly downloads
- [masked](https://npm.io/package/masked.md) — 5.5K weekly downloads
- [@comunica/actor-query-process-explain-logical](https://npm.io/package/@comunica/actor-query-process-explain-logical.md) — 4.7K weekly downloads
- [@veracity/vui](https://npm.io/package/@veracity/vui.md) — 4.6K weekly downloads

## Recent versions

- 1.0.0 (latest) — 2019-07-15

## README

# squl

A collection of SQL utility functions.

## setup

### npm

```shell
npm i squl
```

### es6

```javascript
import squl from 'squl';
```

### node

```javascript
let squl = require('squl');
```

### browser

```html
<script src="https://unpkg.com/squl"></script>
```

The module is globally available as `squl`.

## members

### methods

`.escape(value)`

Escapes a value for safely use in a query.

```javascript

let escapedUndefined = squl.escape(undefined);
// => 'DEFAULT'
let escapedNull = squl.escape(null);
// => 'NULL'
let escapedBoolean = squl.escape(true);
// => '1'
let escapedInteger = squl.escape(4);
// => '4'
let escapedFloat = squl.escape(0.73);
// => '0.73'
let escapedString = squl.escape('DELETE FROM user');
// => '0x44454c4554452046524f4d2075736572'
let escapedArray = squl.escape(['Eric', 'Lisa', 'Carl']);
// => '0x45726963, 0x4c697361, 0x4361726c'
let escapedBuffer = squl.escape(Buffer.from([1, 2, 3]));
// => '0x010203'

```

---

`.buildList(array)`

Builds a list.

```javascript
let string = squl.buildList(['a', 'b', 'c']);
// => 'a, b, c'
```

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