This is currently a limitation of DataAssist. Your fix should work to allow the inserts and updates to occur but like you said it will need to be applied manually on DataAssist pages.
For any others that would like to make use of this code the | character was rendered by the forum, you should use this for the replacement value:
|
Both code samples have been updated