manifold-sql[1] is a schema-first JPA alternative that lets you type-safely inline native SQL in Java source among other capabilities.
DuckDB[2] is a high-performance, in-process database based on PostgreSQL specifically designed for analytics.
Combining manifold-sql and DuckDB results in a uniquely productive platform for analytics with Java.
1. https://github.com/manifold-systems/manifold/blob/master/man...