KQLite

KQLite is light weight Kotlin wrapper over SQLite that provides following features:

Type Safe SQLite DSL Queries
Kotlin Multiplatform
Type Safe Cursor
SQL Familiar Syntax
Null Safety
No Plugins - No generated code

For detailed guide and integration, see KQLite guide

Example KQLite queries

// Using quick convenience APIs
// SELECT * FROM Employees;
Employees.quickSelect().forEach {
    println(it[Employees.name])
}

// Using select() method for customization (optional)
// SELECT * FROM Employees;
Employees.select().execute().forEach {
    println(it[Employees.name])
}

// Specific columns
// SELECT name, age FROM Employees WHERE age > ?;
Employees
    .select(Employees.name, Employees.age)
    .where {
        it.age GT 30
    }
    .execute()
    .forEach {
        println("${it[Employees.name]} - ${it[Employees.age]}")
    }