Kysely - Type-Safe SQL Query Builder

Overview

Kysely is a type-safe TypeScript SQL query builder that provides end-to-end type safety from database schema to query results. Unlike ORMs, it generates plain SQL and gives you full control while maintaining perfect TypeScript inference.

Key Features:

• Complete type inference (schema → queries → results)
• Zero runtime overhead (compiles to SQL)
• Database-agnostic (PostgreSQL, MySQL, SQLite, MSSQL)
• Migration system included
• Plugin ecosystem (CTEs, JSON, geospatial)
• Raw SQL integration when needed