PicnicSupermarket / jolo

jOOQ entity relationship loader.
MIT License
46 stars 4 forks source link

SELECT clause from mapped classes #3

Closed raderio closed 5 years ago

raderio commented 5 years ago

What do you think about this feature

List<MyPojo> list4 = dsl.select(MyPojo.class).from(T).fetch();

https://github.com/jOOQ/jOOQ/issues/9126 https://github.com/jOOQ/jOOQ/issues/9005

It have a lot in common with Jolo.

Mordavolt commented 5 years ago

Hey @raderio, thanks for reaching out.

This looks like a feature that could potentially do some of the things Jolo does. I'd argue that https://github.com/jOOQ/jOOQ/issues/9288 looks even more like Jolo.

That being said, and you can see some great points here https://github.com/jOOQ/jOOQ/issues/9288#issuecomment-535832929, Jooq will likely never fully implement what Jolo does. Jooq is meant to retrieve data the way SQL engine thinks about it, as abstract tuples. We've built Jolo to complement that and in turn map data to a graph of domain objects, which is an OOP way of looking at it.

To sum it up, thanks for the heads up, it would be indeed a nice feature in Jooq, but unlikely that it would be sufficient for us to forgo Jolo. What do you think about it?

Mordavolt commented 5 years ago

Closing since there is nothing to do here.