The info for the ExecuteSQL method of Instance on the DataProvider class is shown to be deprecated. It still works, but I imagine it is marked for later removal. In looking at the other available methods of DataProvider.Instance() I am not finding one that takes in a SQL string with parameters that is not marked as deprecated.

Assuming I have to use dynamic SQL and can't go with a stored proc, what option do I have?