workers-qb

Read the documentation here!

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, 3 databases are supported:

• Cloudflare D1
• Cloudflare Durable Objects
• PostgreSQL (using node-postgres)
• Bring your own Database

Features

• [x] Zero dependencies
• [x] Fully typed/TypeScript support
• [x] Migrations
• [x] Type Checks for data read
• [x] Create/drop tables
• [x] Insert/Bulk Inserts/Update/Select/Delete/Join queries
• [x] Modular selects (qb.select(...).where(...).where(...).one())
• [x] On Conflict for Inserts and Updates
• [x] Upsert