-- Migration Doctor snapshot, SQL export: installed apps (plugin keys) used to attribute workflow rules to apps.
-- Read-only: a single SELECT, no writes, no temporary tables. Output: one JSON object per line.
-- Run (read-only) with psql and save the output as plugins.jsonl:
--   psql -X -q -A -t -v ON_ERROR_STOP=1 -h DBHOST -U READONLY_USER -d JIRADB -f plugins.sql -o export/plugins.jsonl
-- If the Jira tables are not in the default search_path, set PGOPTIONS='-c search_path=your_schema' first.
-- Then pass the export directory to the snapshot script: --sql-export-dir export (bash) or -SqlExportDir export (PowerShell).

SELECT json_build_object(
         'key', pv.pluginkey,
         'name', pv.pluginname,
         'version', pv.pluginversion)
FROM pluginversion pv
ORDER BY pv.pluginkey;