README.md

Kotlin SQLBuilder - A small, lightweight multiplatform library

Kotlin SQLBuilder is a lightweight SQL query builder library written in Kotlin Multiplatform.

This project is inspired by Zeko SQL Builder and is targeted to have a fun dsl to work with.

Feel free to contact me as well if you want to work and improve this library with me!

Project Features

• Kotlin multiplatform.
• Kotlin tests and kotlinx-kover.
• No dependencies.

TODO

• Support HAVING and GROUP BY
• More tests, this is tested with very minimal sql queries

Getting Started

Basic Examples

val sqlBuilder = QueryBuilder()                  // Instantiate your builder.
sqlBuilder.from("user")
sqlBuilder.fields("id, first_name, last_name")
sqlBuilder.sql                                   // returns "SELECT id, first_name, last_name from user

val sqlBuilder = QueryBuilder {                  // Also has a friendly, dsl support.
    fields("id, first_name, last_name")          // .sql outputs the same string above
    from("user")
}

See tests for more examples on usage.

Adding to your project via maven central

WIP