Postgres JSONB operators interpreted as query placeholders

[VRmnv]

Hello everyone!

I'm trying to build following query:

SELECT * FROM image
WHERE
    image.info -> 'panoramic' @? '$.imageId ? (@ == "id1" || @ == "id2")';

In this query i use json operators with question sign.

In my code i use psql.Raw:

psql.Raw("image.info -> 'panoramic' @? '$.imageId ? (?)'", "...")

Howewer only my last '?' is an actual placeholder and i'm getting this error:
Bad Statement: has 3 placeholders but 1 args: image.info -> 'panoramic' @? '$.imageId ? (?)'

How can i build this query with bob?

[stephenafamo]

In this case you should escape the initial ? with a backslash

psql.Raw("image.info -> 'panoramic' @\? '$.imageId ? (?)'", "...")

[VRmnv]

Thanks!

That one worked:

psql.Raw(`image.info -> 'panoramic' @\? '$.imageId \? (?)'`, "...")