A type-safe DSL for NoSQL using Kotlin language (experiment)

gistfile1.kt

import kotlin.nosql.*

object Cities : Table() {
    val id = integer("id").id().generated() // GeneratedPKColumn<Int, Cities>
    val name = varchar("name", 50) // Column<String, Cities>

    val all = id + name // Template2<Cities, Int, String> Select template
    val values = name // Column<String, Cities>
}

Cities insert { values("St. Petersburg") }

// INSERT INTO Cities (name) VALUES ('St. Petersburg') 

for ((id, name) in Cities select { all }) {
    println("$id: $name")
}

// SELECT Cities.id, Cities.name FROM Cities

Cities select { all } filter { name.eq("St. Petersburg") } forEach { id, name ->
    println("$id: $name")
}

// SELECT Cities.id, Cities.name FROM Cities WHERE Cities.name = 'St. Petersburg'