The Native Query

orm.xml

<named-native-query name="customerEntity.getCustomerDetails">
    <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
     ]]></query>
</named-native-query>