Query builder helps you create queries to feed data to a report with a few clicks. It’s an interface between the actual database and the end user. The queries will not affect the actual database; they only fetch data from it.
The SQL query builder is a convenient drag-and-drop user interface that helps both technical and nontechnical users create and view relationships between tables with just a few clicks. It provides both graphical and text-based modes to create SQL queries easily.
Graphical query designer
The graphical query designer displays a hierarchical view of tables, views, and procedures available in the database for interactively building queries. A simple drag and drop to the query design view will generate the queries for your data set.
The text-based query designer lets you write queries in the query syntax that is supported by the data source. A built-in data preview option is available to view the query results.
Table relationships
The query builder provides a dialog interface to manage relationships between tables. You can choose the column names to join the tables.
Provides a user interface to add filters to a data set to limit data. The filter criteria specified in a data set is automatically added to the query during execution.
Provides a user interface to add or manage query parameters for a data set. The query parameters take values at runtime to filter the data. You can use the following parameters in data set queries:
The Blazor Report Designer supports extending the functionalities of the query designer. It allows users to enable a graphical database view for any required data source type that does not have native support.