I haven't tried the other things that you mentioned. I'm not a programmer, and my knowledge of how to use databases is very limited. I know how to do a query, and that's about it. So I'm able to run my query, which is allowing me to refine the data set that I'm looking at. Then I need to make edits to every line item in the result set, so I was hoping to be able to make those edits directly. Without that functionality, I need to go directly into the vastly larger table to update the records, which simply takes a lot more time.
Unfortunately, the necessary features (getting source column and table for each result column) were not implemented in the MS SQL client library. We'll try to support it on the query level (using the static analyzer) but it will not handle complex queries anyway. So currently result editing is only for databases where the client provides necessary information (MySQL, PostgreSQL, SQLite and Valentina databases, as described in documentation)
Did you try the Data Editor filtering (and Data Editor related records) and it doesn't work for your tasks?
Currently, the result editing is not available for MS SQL databases.
This was the limitation of the FreeTDS client library.
In the nearest 1-2 hours we'll review the changes made to this library, maybe necessary functionality was already implemented so we can use it in the Valentina Studio.