kotlin-sqlbuilder
Lightweight SQL query builder library enabling intuitive query construction with no dependencies. Offers a fun DSL and simple instantiation, supports minimal SQL functionalities, and provides test examples.
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!
- Kotlin multiplatform.
- Kotlin tests and kotlinx-kover.
- No dependencies.
- [ ] Support HAVING and GROUP BY
- [ ] More tests, this is tested with very minimal sql queries
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.
WIP
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!
- Kotlin multiplatform.
- Kotlin tests and kotlinx-kover.
- No dependencies.
- [ ] Support HAVING and GROUP BY
- [ ] More tests, this is tested with very minimal sql queries
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.
WIP
