registerFunction( "locate", new SQLFunctionTemplate( Hibernate.INTEGER, "instr(?2,?1)" ) );

select instr('programmer', 'program') === select locate('program', 'programmer');

create table test_1 (id int, description varchar(255))

select id, locate(description, 'program') from table_test;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Table;

import org.hibernate.annotations.Formula;

@Entity
@Table(name = "TEST_1")
public class Test_1_DTO {
   public Test_1_DTO() {
      super();
   }   
   
   private Integer id;
   private String desc;

   @Column(name = "DESCRIPTION", length = 255)
   @Formula(value = "locate(description, 'program')")
   public String getDesc() {
      return desc;
   }

   public void setDesc(String desc) {
      this.desc = desc;
   }

   @Id
   @Column(name = "ID")
   @GeneratedValue
   public Integer getId() {
      return id;
   }

   public void setId(Integer id) {
      this.id = id;
   }

   public Test_1_DTO(Integer id, String desc) {
      super();
      this.id = id;
      this.desc = desc;
   }
}

import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
import org.hibernate.SessionFactory;

...

AnnotationConfiguration aconf = new AnnotationConfiguration();
Configuration cfg = aconf.configure("hibernate.cfg.xml");
SessionFactory sessionFactory = cfg.buildSessionFactory();

Session session =  sessionFactory.openSession();
session.beginTransaction();
Test_1_DTO obj = session.load(Test_1_DTO.class, 1);
session.getTransaction().commit();

select test_1_dto0_.ID as ID0_0_, instr('program', test_1_dto0_.description) as formula0_0_ from TEST_1 test_1_dto0_ where test_1_dto0_.ID=?

select test_1_dto0_.ID as ID0_0_, test_1_dto0_.ddd as ddd0_0_, locate(test_1_dto0_.description, 'program') as formula0_0_ from TEST_1 test_1_dto0_ where test_1_dto0_.ID=?