After finding my workaround for this issue, I still could not get the HTML escaping right.
Until I found out that that was not a SQL issue but a display issue.
Query: SELECT 'Fish & Chips'
Output: Fish & Chips
Desired: Fish & Chips
After finding my workaround for this issue, I still could not get the HTML escaping right.
Until I found out that that was not a SQL issue but a display issue.
Query: SELECT 'Fish & Chips'
Output: Fish & Chips
Desired: Fish & Chips
![]()
Acknowledging this. We’re making some updates here and will have a look (too).