TMS Query Studio

Trying to address the needs of users who are just exploring the SQL universe, TMS Query Studio allows them to set up advanced queries in a manner that resembles the behavior of a natural language.

TMS Query Studio encapsulates two different components, namely TatVisualQuery and TatMetaSQL, and you simply need to drop the software utility on the form and make sure you connect to your database in order to benefit from the goodies it puts at your disposal.

Before anything else, it is worth bringing into discussion the purpose of each of the two aforementioned components. While the former allows front end-users to come up with their own SQL statements in an environment that requires little previous experience, the latter is a non-visual component that proposes an object-oriented architecture that integrates an SQL statement.

To be more specific as to the product’s capabilities, it should be pointed out that it allows you to effortlessly handle visual definitions of SQL along with definitions of order and filtering, tables and joins, and more.

In case you opt for Microsoft SQL Server, Microsoft Access, Nexus, Oracle, Interbase, MySQL, SBISAM, or Local BDE, you may want to know that you should be covered as TMS Query Studio supports syntax for each of every one of them.

Moreover, an exclusive parameter editors feature is integrated for enhanced control, and custom filter conditions as well as field expressions should be easy to achieve.