How can you modify an automatically generated SQL query within a Spring application?

In Spring applications, when using JPA (for example, with Hibernate), the automatically generated SQL queries can be modified in several ways:

1. Using annotations in entities — for example, @Table, @Column, @JoinColumn allow influencing the structure of queries.

2. Configuring Hibernate through properties — you can change the dialect, enable SQL logging, configure caching.

3. Using EntityManager and Criteria API — for programmatically building queries with the desired conditions.

4. Overriding repository methods — writing custom JPQL or native queries using @Query.

5. Using Hibernate Interceptor or EventListener — to intercept and modify SQL at the session level.

6. Using JpaSpecificationExecutor — for dynamic query building.

Example of using @Query for a custom query:

public interface UserRepository extends JpaRepository<User, Long> {
    @Query("SELECT u FROM User u WHERE u.status = ?1")
    List<User> findByStatus(String status);
}

If you need to change the SQL generated by Hibernate itself, you can use hibernate.session_factory.interceptor or write your own Dialect.

Thus, modifying the automatically generated SQL in a Spring application is achieved through annotations, custom queries, the Criteria API, and if necessary — through extending Hibernate's functionality.