Using VB.NET Strong Typed Datasets and/or standard SQL Server Code, is there a way to obfuscate the query so that a SQL statement with multiple table Joins is obfuscated from anyone with access to the SQL Server (reviewing transaction logs, analyzer, etc.)?
1) Assume that the VB.Net Winforms only has access read-only access to the tables (no stored procedure, no "views" access)
2) No LINQ to SQL (too difficult with LEFT/RIGHT joins, and and multiple JOINS)
Essentially, I would like to hide how the tables are joined together, as it has taken a while to get this right.