Can you explain what JPA Specifications are and how they are used when working with databases?

JPA Specifications are a way to dynamically construct database queries in Java using the Criteria API. They allow describing selection conditions as objects that can be combined and reused.

The main idea is to create an interface Specification<T>, where T is the entity type, and implement the method toPredicate, which returns a condition for the query. This is convenient for complex filters that may change during execution.

Example of usage:

public class UserSpecification implements Specification<User> {
    private SearchCriteria criteria;

    public UserSpecification(SearchCriteria criteria) {
        this.criteria = criteria;
    }

    @Override
    public Predicate toPredicate(Root<User> root, CriteriaQuery<?> query, CriteriaBuilder builder) {
        if (criteria.getOperation().equalsIgnoreCase("equals")) {
            return builder.equal(root.get(criteria.getKey()), criteria.getValue());
        }
        // other operations
        return null;
    }
}

In the repository, you can use Specification:

List<User> users = userRepository.findAll(Specification.where(new UserSpecification(new SearchCriteria("name", "equals", "John"))));

Thus, JPA Specifications help create flexible, reusable, and type-safe database queries.