Have you had experience using API Criteria in JPA for building dynamic queries?

Yes, the API Criteria in JPA is used for building dynamic and type-safe database queries. Instead of writing JPQL strings, you create queries programmatically, which allows for flexible condition formation depending on the application's logic.

Example of using the Criteria API to select users by name:

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("name"), "Ivan"));
List<User> results = entityManager.createQuery(cq).getResultList();

This approach is convenient when query parameters may change during execution and helps avoid errors in query strings.