I spent way to much time asking ChatGPT 3.5 and always reliable Google search how to escape a single quote using jq, gsub() method.
Unicode Escape for the win: \u0027!
This is a short piece of my code to specifically show how the Unicode Escape works:
gsub("\u0027"; "")
Well that's how I was able to solve this prickly issue!