SQL code against tables with '>' in headers suddenly failing?

[Kayl669]

Just want to post this issue we're experiencing here in case other people are facing something similar. Below is the wording of the support ticket request I've raised:

SQL code that has been working is suddenly failing due to syntax errors today. There have been no changes to the Databricks runtime we use (12.2).

The SQL code that is failing interrogates tables with '>' in the field names. The error is produced when you query these tables in a subquery or CTE and then SELECT from the subquery or CTE. Our code uses backticks to enclose these field names already.

Sample error message:
[PARSE_SYNTAX_ERROR] Syntax error at or near '>'.(line 1, pos 5) == SQL == event>eventData>identityState>customerId -----^^^

[Aviral-Bhardwaj]

Please provide query here, query is not visible in the question

[Kayl669]

Code in the attached .png. Can you see this? Thanks

[Aviral-Bhardwaj]

please dont use back ticks use and whole statement should not be in `` use ' ' for value only 

[Kayl669]

This was code that was working yesterday? You have to use backticks because the field names of the table contain characters akin to spaces?

[Kayl669]

The point that we've got to with this is that MS Support / Databricks have acknowledged that they did something and are working on a fix. "The issue occurred due to the regression in the recent DBR maintenance release...Our engineering team is working on a hotfix for the issue, which should be implemented by tomorrow EOD"