fix(core): return 409 on unique/foreign key constraint violations instead of 500

Co-Authored-By: Claude Opus 4.6 (1M context) <noreply@anthropic.com>