drizzle-orm

You achieve type-safe SQL queries in TypeScript by using a SQL-first ORM that provides compile-time type inference and zero-runtime dependencies, ensuring ergonomic and performant database access without overhead.

Running TypeScript ORM migrations in an edge runtime environment is best handled by combining a lightweight ORM with drizzle-kit, which manages schema migrations while maintaining strong edge runtime compatibility and a minimal footprint.

Yes, this TypeScript ORM supports first-class raw SQL alongside standard query patterns, allowing developers to drop into raw SQL expressions while retaining compile-time type safety and schema inference.

To start querying with a zero-runtime ORM, you define your database schema in TypeScript and use the inferred types directly in your queries, gaining compile-time guarantees without adding runtime dependencies to your bundle.

A SQL-first ORM is chosen over other TypeScript ORMs for server and edge environments because it delivers strong type inference, first-class raw SQL support, and relations management with a lightweight runtime footprint tailored for edge compatibility.