If I use AS inside SQL and with Space, it will throw syntax error

[pyyick]

The following SQL is OK:

 SELECT `increment_id` AS 'Order_ID' FROM `sales_order_grid``

However this one will throw SQL syntax error:

 SELECT `increment_id` AS 'Order ID' FROM `sales_order_grid``

After I drill on var/log/system.log, I found the the resultant SQL is the cause of this error.

SELECT `t`.* FROM (SELECT `increment_id` AS 'Order ID' FROM `sales_order_grid`) AS `t` ORDER BY Order ID DESC LIMIT 20

[nacho2706]

Yeah, that's an issue on the extension.
You can edit the file: Block/Adminhtml/Report/Grid.php in the function addColumnSet($dataItem)

In that file you can modify the line 57:
$data = [
'data' => ['header' => $key,
'index' => $key,
'type' => 'text']
];

for:

$data = [
'data' => ['header' => str_replace("_"," ",$key),
'index' => $key,
'type' => 'text']
];

In that way, you can set the query with the "_" but the backend grid column title will show the right space between the words.

Let me know if you have any questions.

Best,