Easy-Query: One of the Best Java ORM Libraries

Easy-Query is a Java ORM library that aims to provide a developer‑friendly, strong‑typed API for building CRUD and complex queries across multiple databases.

The article introduces the library, provides documentation and repository links, and demonstrates how to write complex SQL queries (group by, sub‑queries, joins) using the fluent lambda style.

Examples include a multi‑column aggregation query, a sub‑query with

SELECT YEAR(date) AS year, MONTH(date) AS month, SUM(income) AS month_income FROM your_table WHERE date >= CURDATE() - INTERVAL 3 MONTH GROUP BY year, month ORDER BY year, month

translated into Easy‑Query Java code, as well as single‑table queries, conditional queries, and pagination.

The framework also supports a wide range of built‑in functions such as trim, leftPad, subString, toLower, format, duration, and date‑time utilities, illustrated with code snippets.

Advanced features such as enum handling, anonymous‑type alternatives using Select.draft, and group‑aware selections are shown, highlighting how Easy‑Query can replace traditional MyBatis or JPA for many use cases.

Finally, the article encourages developers to try Easy‑Query, noting its open‑source nature and compatibility with various Chinese databases.