Custom Multiplatform DB with different dialects

[hfhbd]

Hey, I want to use a Postgres DB from the JVM and from Kotlin native targets so I created a Postgres native sqldelight driver based on libpq.
To use this native driver I created my custom dialect mainly to replace Java apis (time) and the runtimeTypes.

I want to use the same db for all targets.
So do you know any possibility to use different dialects for different targets/sourceSets, but keep using the sqldelight postgres jvm dialect for the jvm? Or is this case too special and I "just" have to include jvm support in my custom dialect? :D

[AlecKazakova]

no this isn't possible because the generated code is only made once and so it has to have the same driver/cursor/statement types for all targets

[hfhbd]

Ah, you are right. But I found a workaround: we put the database schema in a common module with only kotlin types (kotlinx.datetime etc) and use dependency in another module for the actually queries for each target and its platform driver/cursor. Unfortunately this results in sql code duplication but a gradle tasks checks if the files are equals.