sql parser error when using mssql FOR JSON PATH

[Pieter3033]

Hi,

The newest form component is really cool 🔥.

I am currently struggling to populate the options of a select type in the form component.
I am using MSSQL.

I have attempted the following:
(SELECT Column1 AS label, Column2 AS value FROM MyTable FOR JSON PATH) AS options

Error:

Note, I have tested this SQL statement inside of MSSQL and the output is as expected.
Maybe I am struggling with the syntax?

Regards

[lovasoa]

Hello ! This looks like an issue in the SQLPage SQL parser, which does not support the non-standard Microsoft SQL syntax for json.

Let's move the discussion to this issue: #127

I'll provide a workaround to use until the underlying parsing issue is fixed.