Have you used Criteria API for building database queries?

Criteria API in Java is a type-safe and object-oriented way to construct database queries, commonly used with JPA (Java Persistence API).

Instead of writing string-based JPQL queries, Criteria API allows creating queries programmatically, reducing errors and increasing flexibility.

Example of a simple query with Criteria API:

CriteriaBuilder cb = entityManager.getCriteriaBuilder();
CriteriaQuery<User> cq = cb.createQuery(User.class);
Root<User> user = cq.from(User.class);
cq.select(user).where(cb.equal(user.get("status"), "ACTIVE"));
List<User> activeUsers = entityManager.createQuery(cq).getResultList();

This approach is convenient when queries are built dynamically, for example, with different filtering conditions.