Easier api to use and support for sqlite

[gitzhan]

Use case

It was a surprise to find this supported r2dbc‘s’ library! thanks a lot to author!

I'm a developer for android & desktop by compose-multiplatform (sometime also use kotlin to coding server side).
In android and desktop case, the database used by sqlite.

Describe the solution you'd like

1、Very much looking forward to a sqlite library that supports r2dbc

2、Can the current database api be more streamlined and easy to use。
for select some data,Need to call like this
Current:
val result = database.runQuery {
QueryDsl.from(metamodel).where { someConditions }
}
Expect such as (Some solutions for Reduced call level by ksp):
val result = database.select(metamodelHolder).where { someConditions }
The usage idea comes from ktorm's sql dsl the one I'm currently using,but this lib has no plan to supported r2dbc(which feature I've been looking forward for a long long time)

[nakamura-to]

Thank you for your interest in Komapper.

1、Very much looking forward to a sqlite library that supports r2dbc

Komapper is an OR mapper that utilizes JDBC/R2DBC drivers.
Are you aware of any stable R2DBC drivers for SQLite?

2、Can the current database api be more streamlined and easy to use

Ktorm's style needs intermediate operations and terminal operations.
Those operations make it difficult to understand when SQL is issued, which can be a source of trouble.
The code in Komapper might seem verbose, but it makes clear when SQL is issued.