Valentina Studio Features In Depth

Build, test and execute SQL queries visually, drag-drop with Query Builder.

You can construct and generate SQL queries without actually knowing SQL. Select only the tables you need, then drag to link them together. Set up your Select logic, then interactively preview the results of the query. Once you are happy with the results, you can move your generated query over to the full SQL Editor.

 Valentina Query Editor


Drag and Drop Database Objects Visually

Drag tables you want to use in your query into this area, then establish how table fields relate between them.

Drag tables you want to use in your query into this area. This diagram shows table fields and relationships (the links) between tables.


Build Queries Visually Using a Standard Paradigm

Valentina Studio Query Builder uses a familiar paradigm found in other database and spreadsheet products for working with tables, filters and functions. It works with the tables, views and other objects added to the work area.

Valentina Studio Query Builder uses a familiar paradigm found in other database and spreadsheet products for working with tables, filters and functions.


Generate SQL Easily

Just click on the Query Tab to find the SQL statement generated from Query Builder.

See the result of a visual query built and the generated SQL code as a result.


See the Result of Your Query Immediately

On the Result Tab, you can see the actual result of the SQL query.

On the Result Tab, you can see the actual result of the SQL query.

Transfer the results of the Query Builder to the Valentina Studio SQL Editor for additional optimization.


Colorize Tabs & Objects in Query Builder

Individually colorize tabs, tables and other objects to make them easier to track in Query Builder.

Set Object Colors in the Query Editor


Work with Virtual Links

Virtual Links support is a special feature of Valentina Studio PRO. Virtual Links provide a mechanism similar to Foreign Keys, but they are not stored within a database or, modify a database itself.

Virtual Links Support in Valentina Studio PRO Query Builder

 

 

STUDIO
See Queries

PRO
Share Queries
Colorize Tabs & Objects
Virtual Links in Query Builder