Jooq is great and sooner or later it will end up looking like this
http://getquill.io
But it all feels a bit too "magical" for me. Seems like you're trading one class of bugs - hand-written SQL mismatching your types - for another - this magic doing something unexpected when you try to do something weird. But maybe it's really really good and that second class of bug never happens. I'm just hesitant (and happy with doobie for now).
So, jOOQ will never become quill or end up looking like it.