Bug: SQL Prompt not parsing string concatenation within the OPENJSON function.

alexw

SQL Server allows for the path parameter to be constructed within OPENJSON.
Using this functionality prevents SQL Prompt to run Code Formatting/Correction on the query.

CROSS APPLY OpenJson(D.JSONColumn,'$.path.' + tableAlias.[pathColumname])

The error is a Script parsing Error: Incorrect syntax near + 

Mac_F

Hi Alex,

Thank you for your question regarding SQL Prompt. We have been able to reproduce this issue, and I an escalating the matter to our senior engineers to confirm. I will let you know as soon as possible with a meaningful answer to provide.

Kind regards,