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

import { sqlx } from 'ts-sqlx';
import { queryOne } from './db';

export const random = await queryOne(
	sqlx(
		`select
		'{1,2,3}'::int[] as intarray,
		'{"a", "b", "c"}'::text[] as textarray,
		int4range(1, 3) as int4range,
		now() as now,
		'{"count": 1}'::jsonb as jsonb,
		'{now(), now()}'::timestamptz[] as timestamptzarray,
		daterange('2014/01/01', '2014/01/31', '[]') as daterange,
		interval '1 year' as interval
`,
		'another'
	)
);
console.log(random);