Thanks for the reply anton.
How would you make use of a stored procedure based table on the client side?
What mechanism would you use to pass the parameters and retrieve the table generated ?
As I said, I can make use of a custom server method to code around, but is there an easier way to get SQL statement level command OPTION (RECOMPILE) in to a DA query ?
I can understand the SP table not being supported as you say, but equally, I could see that the client might be agnostic as to how the table was presented by the server. One of your own blog posts almost (but not quite) says this :-
This the easiest scenario. At the same time, Data Abstract makes it possible to, for example, define a Schema table that exposes data from a complex SQL query involving joins of several tables as a plain table. Given that the needed SQL statements (either stored procedures or plain SQL statements) are defined to handle insert, update and delete operations, the client application will work with the data as if it was a simple plain table. Furthermore, if in the future the data source structure will be changed (for example if a data table containing the needed data will be introduced to the database schema) it would be possible to point the Schema table to this changed data source without changing a line of code in either the server or the client application.