Named Parameter

orm.xml

    <!-- Search Customer By First Name -->
    <named-native-query name="customerEntity.searchCustomerByFirstName">
        <query><![CDATA[
            SELECT
                cust.id as customerId,
                cust.FIRST_NAME as firstName,
                cust.LAST_NAME as lastName,
                cust.CITY as city,
                cust.COUNTRY as country,
                corder.ORDER_NUMBER as orderNumber,
                corder.TOTAL_AMOUNT as totalAmount
            FROM CUSTOMER cust LEFT JOIN CUSTOMER_ORDER corder
                 ON corder.CUSTOMER_ID = cust.ID
            WHERE
                 cust.FIRST_NAME = :firstName
         ]]></query>
    </named-native-query>