@Entity
public class User {
    private String name;
    private String lastName;
    private String address;

//getters, setters
}

    
@Override
    public List<User> getUsers(String name) {

        List<User> users = Collections.emptyList();
        try {
            Query usersQuery = entityManager.createNamedQuery("User.findAllUserByName");
            usersQuery.setParameter("p_name", name);
            usersQuery.setMaxResults(50);

            users = usersQuery.getResultList();
        } catch (Exception e) {
            //обработка ошибок
        }
        return users;
    }

<named-native-query name="User.findAllUserByName" result-class="com.example.entity.User">
    <query>select*from table(search.search_user(p_name=>:p_name))</query>
</named-native-query>

select name, lastname from table(search.search_user(p_name=>:p_name))

@Entity
@NamedNativeQuery(
                name = "User.findAllUser",
                query = "SELECT user_Id, name, lastName FROM sameTable",
        resultClass = User.class
)
public class User {
    private long userId;
    private String name;
    private String lastName;

    private String address;


    @Id
    @Column(name = "USER_ID")
    public long getUserId() {
        return userId;
    }

    public void setUserId(long userId) {
        this.userId = userId;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

}

            
            Query usersQuery = entityManager.createNamedQuery("User.findAllUser");
            List<User> user = usersQuery.getResultList();