Add DB2 Dialect

[hfhbd]

Description

I want to use DB2 sql server from Kotlin (JVM). A similar feature request exists for Exposed (JetBrains/Exposed#930)

https://www.testcontainers.org/modules/databases/db2/ supports db2 as well.

I would start to implement it, if you want to have this dialect here.

[AlecKazakova]

with the dialect api this doesn't need to live in sqldelight, and other dialects will probably move out at some point. If someone else builds a dialect for db2 I'm happy to link to it in the docs but I won't be adding more dialects myself

[hfhbd]

I agree. So with the new dialect module, it is possible to use 3rd party dialects? Nice!

[AlecKazakova]

yes!

[dudil]

with the dialect api this doesn't need to live in sqldelight, and other dialects will probably move out at some point. If someone else builds a dialect for db2 I'm happy to link to it in the docs but I won't be adding more dialects myself

Hi @AlecStrong , @hfhbd were you able to add the the dialect? Is there another project currently running for it?

[hfhbd]

It is indeed on my (big) backlog :D
I definitely need it later this year. If you need it too, I could start prototype it in the next days, and any contributions are welcome!

[dudil]

Absolutely yes! 🙏
Would be happy to work on that with you

[hfhbd]

@dudil I created an initial dialect. I will add features/missing dialects on demand. As I don't use the dialect yet, feel free to create issues, and PRs :)
I will publish a initial release soon.
https://github.com/hfhbd/sqldelight-db2-dialect

[hfhbd]

@dudil I released an initial version:

sqldelight {
    database("DB") {
        dialect("app.softwork:sqldelight-db2-dialect:0.0.1")
    }
}

It should work, but I depend on a snapshot version of sqldelight, so you have to use id("app.cash.sqldelight") version "2.0.0-SNAPSHOT" too.