Viewing profile — lukaseder

Informix also supports MULTISET natively. Many others support ARRAY, which is equivalent for all practical purposes. jOOQ popularised MULTISET over ARRAY because the existing ARRAY…

ISO/IEC 9075-2:2023(E) 10.9 : ::= ARRAY_AGG [ ORDER BY ] I hope this helps

You get that in Kotlin. Or r.getId(), r.getFirstName(), etc. in Java. So what's the issue here?

jOOQ is also a great option if you do like stored procedures

Not sure what you mean. I meant that without declaration site variance, ("pragmatic") unsafe casting is everywhere in jOOQ's internals. Without being able to capture wildcards in l…

jOOQ's internals are full of unsafe casts, though.

jOOQ doesn't get involved in any such prefetch/eager fetch shenanigans, which are often wrong. They work for some cases and do too little/too much for others. So, specifying the ex…

Everyone has a different set of "serious" flaws to share.

> (with the possible exception of JOOQ, whose open source version is unfortunately also very limited) How is it "very" limited?

> Not sure how successful jOOQ has been financially, but considering they've been around for many years at this point, I have to imagine it's worked out well enough to pay for the …

I don't know if your various flatMap / etc methods are purely implemented in the client (it would be quite bad from a performance perspective? But since you're implementing reducer…

> This may be more intuitive for some developers, especially those that don't use SQL all the time. I tend to recommend my famous talk to such developers: https://www.youtube.com/w…

What, you can't just say that and not link to the issue!

The "object oriented" in jOOQ Object Oriented Querying stands for an object oriented query model, not mapping to object oriented target data structures.

Regarding 4) among the pros, jOOQ does this (opt in): https://www.jooq.org/doc/dev/manual/sql-building/queryparts/... . It's being done at runtime, thus probably not to be done in …

All of them

SQL is powerful. A DSL that "fixes" things in this area getting all the other language feature interactions right isn't trivial, all the while users have to learn yet another langu…

> There are tradeoffs everywhere though, so with Jooq you still aren't 1-to-1 with raw SQL You're probably hinting at writing derived tables / CTEs? jOOQ will never keep you from w…

Then don't leave

Why would it do that? It's a library for type safe, dynamic SQL building in Java...

I made https://www.jooq.org . Then hired myself in the company I created to maintain jOOQ

>Totally agree. Lukas Eder has some nice presentations about it. Thanks for the shout out! For the record, that's probably the referenced talk: https://www.youtube.com/watch?v=wTPG…