SQL Parser throws a syntax error for a T-SQL query that contains 'ENSP' HTML space notation (4377058)

SQL Parser throws a syntax error for a T-SQL query that contains 'ENSP' HTML space notation

The SQL Parser throws a syntax error for any T-SQL query containing the 'ENSP' HTML space notation, resulting in the file being sent to the quarantine folder. 
Please see the error from the ApexSQL Audit log files:

2024-09-19 14:36:51.815 DEBUG [SERVER_NAME\SQL19]: SQL Parser exited with code 1
2024-09-19 14:36:51.815 DEBUG [SERVER_NAME\SQL19]: syntax error, state:1351(10100) near:                         where(21,1)
2024-09-19 14:36:51.852 ERROR [SERVER_NAME\SQL19]: An exception occurred
Cannot parse SQL text data
Type: ApexSQL.Audit.Processor.Distributed.Trace.TraceException
Stack trace
  at ApexSQL.Audit.Processor.Distributed.Parser.SqlParserHelper.GetParsedObject(String sql, Boolean parseColumns)
 

WORKAROUND:
Use SQL Audit technology for auditing instead of Extend events technology or exclude the application/login (ENSP) from the auditing process
 
STATUS:
The new parsing engine has addressed the issue, and the fix will be included in an upcoming GA release of ApexSQL Audit.

234940