I just migrated my sqldelight to 2.0.0 and I found out the syntax got much uglier. I used to instantiate my db in this way:

internal val localDb by lazy { LocalDb(sqlDriver) }

and now it seems I need to do this way:

internal val localDb by lazy { LocalDb(sqlDriver, Countries.Adapter(IntColumnAdapter,IntColumnAdapter,IntColumnAdapter)) }

because I have 3 integers, which for some reason require an adapter. Wasn't it possible to implicitly avoid such verbose definition?

We chose not to. You only do this once so it really doesn't matter

This is the table I defined in Countries.sq:

import <http://kotlin.Int|kotlin.Int>;
import kotlin.Boolean;

CREATE TABLE Countries (
    name TEXT NOT NULL PRIMARY KEY,
    population INTEGER AS Int NOT NULL,
    first_doses INTEGER AS Int NOT NULL,
    fully_vaccinated INTEGER AS Int NOT NULL,
    favorite INTEGER AS Boolean NOT NULL DEFAULT 0
);

This is what got generated:

public data class Countries(
  public val name: String,
  public val population: Int,
  public val first_doses: Int,
  public val fully_vaccinated: Int,
  public val favorite: Boolean,
) {
  public class Adapter(
    public val populationAdapter: ColumnAdapter<Int, Long>,
    public val first_dosesAdapter: ColumnAdapter<Int, Long>,
    public val fully_vaccinatedAdapter: ColumnAdapter<Int, Long>,
  )
}

Documented here: https://cashapp.github.io/sqldelight/2.0.0/upgrading-2.0/#runtime-changes

Yes, I saw that, but it doesn't specify that you need to pass an adapter object to the DB instance invoker. I guess it shouldn't be a difficult task to automatically generate the invoker function to still get a single parameter:

public operator fun invoke(driver: SqlDriver): LocalDb {
      val adapter = Countries.Adapter(IntColumnAdapter,IntColumnAdapter, IntColumnAdapter)
      return LocalDb::class.newInstance(driver, adapter)
    }

That behavior is generally unchanged in relation to 1.x. You always had to supply adapters where they were needed to do column mapping. I guess the difference is now that more adapters are generated whereas before they may have not been needed.

Ok, I see. That must be because `Int`s now require an adapter. But I believe the API of the invoke function could be simplified very easily. Not much effort required.