ts_sqlx 0.1.3

Typescript SQLx compile-time checked queries without a DSL.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

# ts-sqlx

[![license](https://img.shields.io/badge/license-MIT%2FApache--2.0-blue")](LICENSE-MIT)
[![npm (scoped)](https://img.shields.io/npm/v/ts-sqlx)](https://www.npmjs.com/package/ts-sqlx)

Typescript SQLx compile-time checked queries without a DSL. see main [package](https://github.com/nathanfaucett/ts-sqlx)

```typescript
import { sqlx, type SqlxString } from 'ts-sqlx';
import Pool from 'pg-pool';

const pool = new Pool();

function query<P extends unknown[], R = unknown>(
	query: SqlxString<P, R>,
	...params: P
): Promise<R[]> {
	return pool.query(query, params).then((result) => result.rows);
}

const post = await query(sqlx('select p.* from posts p where p.id = $1;'), 1);
console.log(post);
```

See [example](https://github.com/nathanfaucett/ts-sqlx/tree/main/node/example) for a "full" project example