airsequel / airsequel-issues Goto Github PK

This happens e.g. for view columns.

Add option to /dbs/xxx/settings to set PRAGMA trusted_schema = True;

I noticed the following regression 1 or 2 days ago:

I have the following view:

CREATE VIEW "cleaned_json_store" AS select distinct
  ...
  json_extract(json, "$.lastUpdatedTime") as updated
from json_store
order by updated

When I want to add other views (or any queries really) building on top of the view above, I get the error

select * from cleaned_json_store

Parse error near line 6: unsafe use of json_extract()

This used to work before but now sure how I can find or report the build nr. or version of airsequel I am using. I wasn't able to find this specific error message online, wondering if this is an airsequel error or sqlite error. It might also help to get a bit more information about the error or a way to inspect what the final query was to which the error line etc. relates to.