In an hibernate.xml you might have:

<hibernate-mapping>
   <class name="com.comp.Addresses" table="ADDRESSES" dynamic-update="true">
   	  <id name="lineNumber" column="LINE_NUMBER" type="integer"></id>
      <property name="ardId" column="ARD_ID" type="integer">
      </property>
      <property name="exchangeSite" type="string">
         <column name="EXCHANGE_SITE" not-null="true" length="255" />
      </property>
	</class>
	<sql-query name="com.comp.Addresses.Addresses">
		<return alias="Address" class="com.comp.Addresses"/>
		<![CDATA[ 
		WITH tokens AS (
    SELECT substr(',' || :address, s + 1, e - s - 1) e, rownum n FROM (
                    SELECT  instr(' ' || :address, ' ', 1, level) s
                          , instr(' ' || :address || ' ', ' ', 1, level + 1) e 
                      FROM dual CONNECT BY instr(' ' || :address, ' ', 1, level) != 0
            )
), token_without_number as (
    SELECT e, rownum n FROM tokens WHERE not(regexp_like(e, '[0-9]'))
), token_with_number as (
    SELECT e, rownum n FROM tokens WHERE regexp_like(e, '[0-9]')
) select
      Address.LINE_NUMBER AS {Address.lineNumber} 
    , Address.ARD_ID AS {.ardId}
....
  from (....)
	]]>
	</sql-query>
	<query name="com.comp.Addresses.getByArdKey">
		From Addresses as nv WHERE nv.ardId = :ardKey		
   </query>
</hibernate-mapping>

Please add support for sql completion in hibernate.
Also add support for the <query ... part.



Product Version = NetBeans IDE 7.4 (Build 201310111528)
Operating System = Linux version 3.8.0-32-generic running on amd64
Java; VM; Vendor = 1.7.0_45
Runtime = Java HotSpot(TM) 64-Bit Server VM 24.45-b08