3 ms·
You can get some benefits you mention by using query builders (like jOOQ). They can get unwieldy at times (not part of the language), but you can drop directly
by isbvhodnvemrwvn 6y ago
You can get some benefits you mention by using query builders (like jOOQ). They can get unwieldy at times (not part of the language), but you can drop directly to SQL if you need to, and they tend to be simpler than ORMs in various use cases.
- cies 6y agoSaw the title, searched the comments for jOOQ. jOOQ needs to be mentioned in this context. With jOOQ you basically write Java-SQL-DSL, and with some code generation from your schema you have really neat type safety (and code completion). String SQL queries are not the answer to ORMs, imho, we need a level in between. jOOQ provides a really cool set of features in that space.
- arusahni 6y agoWasn't familiar with jOOQ - neat! Looks like it covers the same set of use-cases that SQLAlchemy-core handles in Python.