@Where(clause = "enddate >= today")

import org.hibernate.annotations.Where;

import javax.persistence.*;
import java.io.Serializable;
import java.sql.Date;
import java.util.HashSet;
import java.util.Set;

@Entity
@Table(name = "my_table")
public class MyQuery implements Serializable
{
    private Date endDate;
    private String name;
    private MyQuery parId;
    private Set<MyQuery> childs;

    public MyQuery()
    {
        childs = new HashSet<MyQuery>();
    }

    @ManyToOne
    @JoinColumn(name = "par_id")
    public MyQuery getParId()
    {
        return parId;
    }

    public void setParId(MyQuery parId)
    {
        this.parId = parId;
    }

    @Column(name = "full_name")
    public String getName()
    {
        return name;
    }

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

    public Date getEndDate()
    {
        return endDate;
    }

    public void setEndDate(Date endDate)
    {
        this.endDate = endDate;
    }

    @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "parId")
    @OrderBy("code ASC")
    @Where(clause = "enddate >= today")
    public Set<MyQuery> getChilds()
    {
        return childs;
    }

    public void setChilds(Set<MyQuery> childs)
    {
        this.childs = childs;
    }
}

@Where(clause = "enddate >= my_function()")

select full_name, enddate from my_table where enddate >= today