求实现类似以下sql语句，除了原生sql外！！！（其实就是一个临时表子查询）

SELECT
    *
FROM
    (
        SELECT
            *
        FROM
            ` order_history `
        WHERE
            ` customer_id ` = '05033'
        AND ` part_number ` LIKE 'M%'
        ORDER BY
            ` shippingdate ` DESC
    ) history
GROUP BY
    ` part_number `