ALTER TABLE `custom_skill_versions` ADD `semver` text DEFAULT '' NOT NULL;--> statement-breakpoint
UPDATE `custom_skill_versions` SET `semver` = `version` || '.0.0';--> statement-breakpoint
UPDATE `skill_submission_items` SET `result` = json_set(`result`, '$.semver', json_extract(`result`, '$.version') || '.0.0') WHERE `result` IS NOT NULL AND json_extract(`result`, '$.semver') IS NULL;--> statement-breakpoint
CREATE UNIQUE INDEX `custom_skill_versions_semver` ON `custom_skill_versions` (`skill_id`,`semver`);