kysely-org/kysely
Kysely
Kysely is a TypeScript SQL query builder that provides a type-safe interface for constructing and executing database queries. It functions as a database layer that ensures schema compliance and prevents runtime errors by using a fluent interface and a programmable way to build complex SQL statements.
The project features a type-safe database layer capable of inferring return types and aliases from SQL selections and joins. It also includes a SQL migration manager to track and apply schema changes across different environments to keep database versions synchronized.
The toolkit covers relational database integration through dynamic query construction and the execution of raw SQL statements. It allows for the creation of parameterized SQL snippets and the ability to reference tables and columns dynamically at runtime.
Features
- Type-Safe Database Clients - Functions as a type-safe database layer that infers return types and aliases from SQL selections and joins.
- Type-Safe Query Builders - Provides a type-safe query builder that ensures database schema compliance at compile time.
- Dynamic SQL Generators - Builds SQL statements at runtime based on variable inputs while maintaining type safety.
- Fluent Query Builders - Implements a chainable, functional interface for constructing complex SQL queries programmatically.
- Relational Database Connectors - Connects TypeScript applications to relational databases using a fluent interface for data management.
- Schema Mapping Utilities - Maps TypeScript interfaces to database table structures to provide compile-time validation of schema types.
- SQL Query Builders - Provides a type-safe interface for constructing and executing SQL queries to ensure schema compliance.
- Fluent Interfaces - Provides a fluent interface for building complex, type-safe SQL queries through method chaining.
- Query Result Type Inference - Calculates exact return types and aliases for queries by analyzing selected columns and join operations.
- Dynamic Column References - Identifies database columns using names provided at runtime to build queries based on user input.
- Parameterized SQL Templates - Uses tagged templates to separate raw SQL from user values to prevent SQL injection attacks.
- Database Migrations - Includes a migration manager to track and apply schema changes across different environments.
- Migration Management - Includes a migration manager to track and apply schema changes across different environments.
- Raw SQL Execution - Allows the execution of manual SQL statements for complex scenarios that exceed the query builder's capabilities.
- Parameterized SQL Snippets - Creates parameterized SQL fragments using template tags to prevent security vulnerabilities like injection.
- SQL Dialect Adapters - Provides a driver-agnostic layer that adapts SQL syntax across different database engines through a unified API.
- Dynamic Table References - Identifies database tables using names provided at runtime to select specific tables within a query.
- Dynamic SQL Expressions - Allows referencing database columns and tables dynamically at runtime while maintaining a structured query object.
- Databases and Data Tools - Type-safe SQL query builder for TypeScript.
- Search and Databases - Builds type-safe SQL queries.
