2) Generate a dynamic SQL statement server side and execute it. 3) Execute multiple performance-optimized queries client-side and then use LINQ or similar to AND and OR the result sets as necessary.

Does 3.23 support derived tables (aka inline views)? If so, plug the SELECT statement that would have generated the temp. table directly into your main query, and Bob's your uncle.

CData, the company making it easy to connect, integrate, and automate enterprise data, is introducing a new capability for CData Connect Cloud, dubbed the Connect Cloud AI Generator, which is a ...