How kysely-org/kysely works
Main Components
a. Core Query Building Layer:
• QueryBuilder components (found in src/query-builder/)
• To the Expression Builder system (src/expression/)
b. Dialect Layer:
• This as a separate layer below the core
• Four supported dialects (PostgreSQL, MySQL, SQLite, MSSQL)
• Dialect-specific adapters and query compilers
c. Driver Layer:
• Connection management components
• Database connection interfaces
d. Plugin System:
• This as a side component
• Built-in plugins (CamelCase, DeduplicateJoins, etc.)
• Extension points
Component Relationships
[Query Building Interface]
• ↓
[Operation Node Layer]
• ↓
[Query Compiler]
• ↓
[Dialect Adapter]
• ↓
[Database Driver]
Detailed Elements
a. Query Building Layer:
┌─ Query Building Interface ─┐
• SelectQueryBuilder │
• InsertQueryBuilder │
• UpdateQueryBuilder │
• DeleteQueryBuilder │
• MergeQueryBuilder │
• ┘
b. Operation Node System:
┌─ Operation Nodes ─────────┐
• SelectNode │
• WhereNode │
• JoinNode │
• etc. │
• ┘
c. Dialect Support:
┌─ Dialect Layer ──────────┐
• ┌─────┐ ┌─────┐ ┌─────┐ │
• PG │ │MySQL│ │MSSQL│ │
• ┘ └─────┘ └─────┘ │
• ┘
Special Features to Highlight
• Type Safety System
• Migration System
• Plugin Architecture
• Runtime Environment Support
• → Data Flow │
• ⇢ Type Information │
• ⚡ Async Boundary │
• 🔌 Plugin Point │
• ┘