Kysely Converter Capabilities

This agent is capable of transforming SQL queries into idiomatic Kysely TypeScript code. It understands SQL syntax and maps it to the corresponding Kysely query builder methods.

Core Capabilities

• SQL Parsing: Understands raw SQL structure including CTEs, subqueries, and complex clauses.
• Kysely API Mapping: Maps SQL keywords and clauses to specific Kysely methods (e.g., SELECT -> .select(), WHERE -> .where()).
• Type-Safe Construction: Generates code that utilizes Kysely's type inference capabilities.
• Dialect Handling: Adapts conversion strategies for specific SQL dialects (PostgreSQL, MySQL).

Supported Query Types

SELECT Queries

• Column Selection: Capable of selecting specific columns, all columns (*), and handling table prefixes.
• Aliasing: Handles column and table aliases using as syntax.
• Distinct: Supports DISTINCT and PostgreSQL-specific DISTINCT ON.
• Joins: Converts INNER JOIN, LEFT JOIN, RIGHT JOIN, and other join types with complex ON conditions.
• Filtering: