Simple to use TypeScript based database first ORM for postgres.

Example usage:

const books = await db.book
	.where(book => book.author.firstname == "Jan")
	.orderByAscending(book => book.title.lowercase())
	.toArray();

const author = await db.person.find("<a very long uuid>");
const authorsFirstBookFrom2001 = await author.books
	.first(book => book.publishedAt.year == 2001);

authorsFirstBookFrom2001.title = "A new title";
await authorsFirstBookFrom2001.update();

Simple Example Project
Using audits with an express server

Getting started
Database structure
Reading, filtering and ordering data
Altering data
Adding audits
Performance and include

This project is sponsored and supported by inter allied crypsis / ACRYPS and VLVT.IN GmbH.