Column names with prefix / suffix validation?

[rider87]

Hi all,

I would like to have a SELECT like:
String expression = "Select x FROM x WHERE [test] = 'Testuser' ";

At rendering time I will change the placeholder [test] to the real Table / Column.
Currently the validation is failing, because JSQLParser cannot use the [ and ] so it will be throw an exception.

Is there a way to validate the SQL with this kind of placeholders?

Thanks

[manticore-projects]

Greetings.

As per default [ ] indicate Arrays, not field quotes.
You will need to set SquareBracketQuotation when calling the parser in order to allow TSQL [ ] quotes.

Please close the case when solved.

[rider87]

Thank you