workers-qb

Zero dependencies Query Builder for Cloudflare Workers

This module provides a simple standardized interface while keeping the benefits and speed of using raw queries over a traditional ORM.

workers-qb is not intended to provide ORM-like functionality, rather to make it easier to interact with the database from code for direct SQL access using convenient wrapper methods.

Currently, 2 databases are supported:

• Cloudflare D1
• PostgreSQL (using node-postgres)

Features

• [x] Zero dependencies.
• [x] Fully typed/TypeScript support
• [x] Type Checks for data read
• [x] Create/drop tables
• [x] Insert/Bulk Inserts/Update/Select/Delete/Join queries
• [x] On Conflict for Inserts and Updates
• [x] Upsert
• [x] Support for Cloudflare Workers D1
• [x] Support for Cloudflare Workers PostgreSQL (using node-postgres)
• [ ] Named parameters (waiting for full support in D1)