Many applications have the evil feature that asks programmers to create a "Query tool" to allow end users (who don't know SQL or the exact schema of the DB) to create their own queries to look up ...

An alternative - again, if supported - would be to create a view that works the same as the derived table, and use this in your query instead.

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 ...