Can I have a Saved Query in Panther with a JSON selector in it?
QUESTION
How do I used JSON selectors in my Saved Queries if Panther doesn't allow column named with a colon (:
)?
ANSWER
To use a colon as a JSON selector in Panther Saved Queries, you must alias the column name. For example, instead of
select json_object:my_special_field from the_table
try
select json_object:my_special_field as my_field from the_table