Wow @Joe_Mako - it's incredible that you found this!
@djoyus1 - if you want me to try to recreate this, I have my own SQL server at home, and I'm happy to help. All I'll need is the table script (create table xXX) and your flow, and we can see if I can get down to the bottom of this by running a SQL trace server-side to see what's going on and what the actual query and error are.
Let me know - this feels like something that may be worth us doing a bit of extra work to dig into the underlying cause so that we can hand it over to the folk at Atleryx to fix.
:-) these crypic ones are the most fun!