Datasette plugin that adds a custom SQL function for executing jq expressions against JSON values
APACHE-2.0 License
Datasette plugin that adds custom SQL functions for executing jq expressions against JSON values.
Install this plugin in the same environment as Datasette to enable the jq()
SQL function.
Usage:
select jq(
column_with_json,
"{top_3: .classifiers[:3], v: .version}"
)
See the jq manual for full details of supported expression syntax.
You can try this plugin out at datasette-jq-demo.datasette.io
Sample query:
select package, "https://pypi.org/project/" || package || "/" as url,
jq(info, "{summary: .info.summary, author: .info.author, versions: .releases|keys|reverse}")
from packages
Try this query out in the interactive demo.