Create data model with query builder
SQL query builder
The SQL query builder comes with a convenient user interface that helps both technical and nontechnical users to create and view relationships between tables with a few clicks. It contains both graphical and text-based mode to create SQL queries easily.
Graphical query designer
You can explore the database tables in hierarchical view and interactively build the queries for a data set. A simple drag-and-drop of tables to the query design view will generate the queries for your dataset.
Text-based query designer
The text-based query designer lets you write queries in the query syntax that is supported by the data source. You can preview the query result by executing the query. This is the default mode available for built-in data sources except SQL.
You can use one or more related tables to create queries. Query builder provides a dialog interface to manage relationship between sets of two tables. You can specify the column names to join two tables.
Provides a user interface to add filters to a dataset to limit data. The filter criteria mentioned in a data set is automatically added to the query during execution.
Provides a user interface to add or manage query parameters to a data set. The query parameter takes values at run-time to filter the data. You can also add user defined parameters for internal data set query related calculations.
Customize query designer