Toad interprets JSON function (PostGRES DB) as Bind Variables - looking for ways to eliminate that

Toad Data Point
1

Hello all

I have the following in my PostGRES script:

authors @? '$.institutionIdentifiers[].type ? (@ == "RINGGOLD")' as has_institution_ringgold_id,
authors @? '$.institutionIdentifiers[].type ? (@ == "OTHER")' as has_institution_other_id,

Toad Datapoint interprets JSON function (PostGRES DB) as Bind Variables and the screen pops up.
Any suggestions on how to adjust the script. Greatly appreciated.

2

Guessing that TDP doesn't support some advanced functions, especially regarding JSON and related... looking for Dev or Support input.

3

Do you believe I should open a ticket with Tech support? Please advise.

4

I would, if only to confirm whether the product supports the syntax... it's not addressed in the product tech docs...