What would a solution look like using Spring Data JPA for the same task?

Spring Data JPA significantly simplifies working with the database by allowing you to write minimal code for CRUD operations and queries.

Suppose you have an entity User:

@Entity
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name;
    private String email;

    // getters and setters
}

The solution to the task (for example, to get a user by email) using Spring Data JPA would look like this:

public interface UserRepository extends JpaRepository<User, Long> {
    Optional<User> findByEmail(String email);
}

Using it in a service:

@Service
public class UserService {
    private final UserRepository userRepository;

    public UserService(UserRepository userRepository) {
        this.userRepository = userRepository;
    }

    public Optional<User> getUserByEmail(String email) {
        return userRepository.findByEmail(email);
    }
}

Spring Data JPA automatically implements repository methods based on the method name, which eliminates the need to write SQL or JPQL queries manually.

Thus, solving the task comes down to defining a repository interface with the necessary methods and using them in services.