Kysely is a compelling choice for query building with type safety and SQL-shaped expressiveness without adopting a full ORM.

Atomic Object is a software consultancy specializing in custom software development and product design. Readers can learn about software development methodologies, user-centered design principles, and agile practices. With case studies, blog posts, and technical insights, Atomic Object provides  guidance and expertise for building innovative and user-friendly software products.

Atomic Spin

Kysely is a TypeScript SQL query builder that provides strong type safety without the complexity of a full ORM. It catches common database bugs like mistyped column names and incorrect return types at compile time through TypeScript inference. The library offers a thin abstraction over SQL with readable chaining syntax, strongly typed where clauses, intuitive migrations with up/down functions, and automatic type generation from database schemas using kysely-codegen. Unlike ORMs, it stays focused on query building while maintaining SQL-like expressiveness, making it suitable for teams comfortable with SQL who want compile-time safety and lightweight tooling.

Kysely: Type-Safe SQL Without ORM Overhead

Practical Tooling: Migrations and Type Generation

drizzle also does the same maybe better.

The nasty things we do to avoid writing sql

I use prisma mostly. If need more performance or complex then use Kysely.