Kysely Assistant-Accurate SQL-to-Kysely Translation

Example

SQL: 'SELECT * FROM users WHERE age > 30' Kysely: 'db.selectFrom('users').select('*').where('age', '>', 30)'

Scenario

Useful in situations where a developer is familiar with SQL but new to Kysely, facilitating the transition to Kysely's query builder syntax.

Example

Explains how 'db.selectFrom('users').where('age', '>', 30).execute()' translates each part of the SQL query into Kysely syntax, detailing the purpose and usage of methods like 'selectFrom', 'where', and 'execute'.

Scenario

Helpful for beginners or intermediate developers who understand basic SQL but require in-depth understanding of how Kysely structures queries.

Example

Provides step-by-step instructions on building a query like 'INSERT INTO users (name, age) VALUES ('John', 25)' in Kysely, including best practices and syntax nuances.

Scenario

Assists users in constructing complex queries in Kysely, ensuring they adhere to proper syntax and TypeScript standards.