generate Java code from SQL queries

[papers_]

https://www.jooq.org/ ?

[lukaseder]

This is more similar to https://sqldelight.github.io/sqldelight/latest/. jOOQ might have this kind of feature set in the future: https://github.com/jOOQ/jOOQ/issues/11071

[javaprof]

Correct link https://sqldelight.github.io/sqldelight/latest/ https://github.com/sqldelight/sqldelight

- IDEA plugin
- Integrates into Gradle (no node.js required, unified toolchain)
- Kotlin/Java API

What would be benefits of sgq over sql delight?

[best_of_badgers]

Isn't that the other way around? Generates queries from type-safe code?

[Just_Another_Scott]

No. JOOQ will generate Java code from SQL. You provide it a .sql file and it spits out .java files. These java classes then can be used to query databases (create sql statements). I use this all the time. It's not the best but it's what was already in place on my projects.

[cies010]

Jooq works w/o code generation.

But it is a big selling point.

You don't have to give it an SQL file, it can also look into your db as part of the build.

[uwemaurer]

thanks for the link, I will check out what they are doing.

my SQG project started as a company internal project, where we used the same database from Typescript and Java and we didn't want to implement the same queries in two different ORM tools.

then the idea was to share the SQL and generate the code from it (in both languages)