-- Migration Doctor snapshot, SQL export: workflow descriptors (OSWorkflow XML with transitions, conditions, validators, post functions).
-- Read-only: a single SELECT, no writes, no temporary tables. Output: one JSON object per line.
-- Run (read-only) with the mysql client and save the output as workflows.jsonl:
--   mysql --batch --raw --skip-column-names --default-character-set=utf8mb4 -h DBHOST -u READONLY_USER -p JIRADB < workflows.sql > export/workflows.jsonl
-- Needs MySQL 5.7.8 or newer (JSON_OBJECT).
-- Then pass the export directory to the snapshot script: --sql-export-dir export (bash) or -SqlExportDir export (PowerShell).

SELECT JSON_OBJECT(
         'name', w.workflowname,
         'descriptor', w.descriptor)
FROM jiraworkflows w
ORDER BY w.workflowname;