如何在jpa原生查询中执行postgresql json函数查询？

import com.fasterxml.jackson.databind.JsonNode;

@Entity
@Table(name = "your_table")
public class YourEntity {
    @Id
    private Long id;

    @Column(name = "json_data", columnDefinition = "jsonb")
    private JsonNode jsonData;

    // 省略其他字段、构造函数和Getter/Setter方法
}

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

public interface YourEntityRepository extends JpaRepository<YourEntity, Long> {
    @Query(value = "SELECT jsonb_extract_path_text(json_data, 'your_key') FROM your_table", nativeQuery = true)
    String executeJsonFunctionQuery();
}

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service
public class YourService {
    private final YourEntityRepository repository;

    @Autowired
    public YourService(YourEntityRepository repository) {
        this.repository = repository;
    }

    public String executeQuery() {
        return repository.executeJsonFunctionQuery();
    }
}