def get_order_by_parts(order_by):
    """
    Extract the order by clause information. In future this could be used to update multiple column ordering.
    :param order_by: the order by clause, for example: ' ORDER BY column_name ASC/DESC'
    :return: order by field name, order by order. For example: column_name, ASC/DESC
    """
    order_by_parts = order_by.replace(' ORDER BY ', '').strip().split()

    return order_by_parts[0], order_by_parts[1]