Need code syntax highlighting for SQL

[yorkshire-pudding]

Adding this page, I could only add as Plain Text

These would look like

greatest(coalesce(`field_data_field_event_date`.`field_event_date_value`, 0), coalesce(`field_data_field_other_date`.`field_other_date_value`, 0))

SELECT `node`.`title` AS `node_title`, `node`.`nid` AS `nid`,
 `field_data_field_event_date`.`field_event_date_value` AS `field_data_field_event_date_field_event_date_value`,
 `field_data_field_other_date`.`field_other_date_value` AS `field_data_field_other_date_field_other_date_value`,
 'node' AS `field_data_field_event_date_node_entity_type`,
 'node' AS `field_data_field_other_date_node_entity_type`, 
greatest(coalesce(`field_data_field_event_date`.`field_event_date_value`, 0), coalesce(`field_data_field_other_date`.`field_other_date_value`, 0)) AS `views_sort_expression_0`
FROM 
{node} `node`
LEFT JOIN {field_data_field_event_date} `field_data_field_event_date` ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0')
LEFT JOIN {field_data_field_other_date} `field_data_field_other_date` ON node.nid = field_data_field_other_date.entity_id AND (field_data_field_other_date.entity_type = 'node' AND field_data_field_other_date.deleted = '0')
WHERE (( (`node`.`status` = '1') AND (`node`.`type` IN  ('event', 'event_other')) ))
ORDER BY views_sort_expression_0 ASC, field_data_field_event_date_field_event_date_value ASC, field_data_field_other_date_field_other_date_value ASC

but currently look like

greatest(coalesce(`field_data_field_event_date`.`field_event_date_value`, 0), coalesce(`field_data_field_other_date`.`field_other_date_value`, 0))

SELECT `node`.`title` AS `node_title`, `node`.`nid` AS `nid`,
 `field_data_field_event_date`.`field_event_date_value` AS `field_data_field_event_date_field_event_date_value`,
 `field_data_field_other_date`.`field_other_date_value` AS `field_data_field_other_date_field_other_date_value`,
 'node' AS `field_data_field_event_date_node_entity_type`,
 'node' AS `field_data_field_other_date_node_entity_type`, 
greatest(coalesce(`field_data_field_event_date`.`field_event_date_value`, 0), coalesce(`field_data_field_other_date`.`field_other_date_value`, 0)) AS `views_sort_expression_0`
FROM 
{node} `node`
LEFT JOIN {field_data_field_event_date} `field_data_field_event_date` ON node.nid = field_data_field_event_date.entity_id AND (field_data_field_event_date.entity_type = 'node' AND field_data_field_event_date.deleted = '0')
LEFT JOIN {field_data_field_other_date} `field_data_field_other_date` ON node.nid = field_data_field_other_date.entity_id AND (field_data_field_other_date.entity_type = 'node' AND field_data_field_other_date.deleted = '0')
WHERE (( (`node`.`status` = '1') AND (`node`.`type` IN  ('event', 'event_other')) ))
ORDER BY views_sort_expression_0 ASC, field_data_field_event_date_field_event_date_value ASC, field_data_field_other_date_field_other_date_value ASC

This would also be useful for the Database API pages

[izmeez]

A couple of links that maybe useful:

https://billauer.co.il/blog/2021/12/tinymce-syntax-highlighting/

https://highlightjs.org/