I have sort of an odd situation. I have a lot of distributed machines working on a simulation. They each start out with their own work, process it, and eventually put it into a SQL database ...

SQL server will allow zero-length strings without issue, as long as your datatype supports it. Just assign the string value of ('') and you're done, no headaches.

Text-to-SQL Experience: Dremio introduces an intuitive and seamless Text-to-SQL experience, allowing users to effortlessly convert natural language queries into SQL directly within the user interface.