https://www.tag-connect.com/solutions-target-devices/usb-ser...
They have FTDI versions as well, for those who want the full USB boot/reset treatment.
Also, they have another connector for attaching to castellated edges. I think it's just so clever.
I have had one too many arguments with firmware people who think these things are sufficient for production that I am just done with them by now. There are other ways to do it.