I have found thread where it is stated that XANO uses JSONB column for storing JSON data internally.
I have JSON column(s) in my tables and I would like to fetch data in more advanced ways using JSONB querying operators - for example I'm interested in using "?" operator to find if my JSON data has certain keys
However when using "?" in DIrect Database Query it seems to interfere with https://docs.xano.com/working-with-data/functions/database-requests/direct-database-query#statement-arguments Statement Arguments where question mark is used to mark position of a variable - I cant find any documentation on how to disable/escape Statement Arguments.
1) How can I run that query? It seems that there is no way to disable Statement Arguments for Direct Database Query?
I would like to avoid need to iterate over records in functions as this will be slow and inefficient.
2) Are there other limitations when one wants to use standard PG operators for working with JSON/B? https://www.postgresql.org/docs/10/functions-json.html