Kotlin Multiplatform Academy · Lesson

Insert, Query & Update Rows

Run CRUD operations from shared code.

Reach the Generated Queries

Your database exposes a queries object named after the .sq file. Every labeled statement becomes a method on it.

val queries = database.playerQueries

Add an insert label in your .sq file. SQLDelight turns its placeholders into typed Kotlin parameters.

insertPlayer:
INSERT INTO player(id, name) VALUES (?, ?);