Query Builder Form Guide

The Query Builder Engine allows administrators to create dynamic SQL queries without manually writing complex SQL statements. Queries can be used by List Views, Form Views, Dashboards, Reports, APIs, and Workflow Automations.

Overview

Query Builder provides a visual interface for designing SQL queries dynamically.

  • Create SELECT queries
  • Configure joins
  • Apply conditions
  • Manage aggregations
  • Generate reports
  • Build reusable datasets

Query Builder Information

Field Description
Query Builder Name Business-friendly query name.
Query Builder Slug Unique query identifier.
Base Table Main table used by the query.
Query Description Description of query purpose.
Query Type SELECT, INSERT, UPDATE or DELETE.
Store Variable Variable name used to store query results.

Column Selection

Select the fields that should be returned by the query.

  • Select database columns
  • Configure aliases
  • Add calculated fields
  • Manage output structure

Join Configuration

Joins connect multiple tables together for retrieving related information.

  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • FULL JOIN

Conditions (WHERE)

Conditions filter records returned by the query.

  • Equal To
  • Not Equal To
  • Like
  • Between
  • In
  • Null Checks

Group By Configuration

Group records for aggregations and reporting.

Having Conditions

Apply filters on grouped results.

Order By Configuration

Sort query results using one or more fields.

  • Ascending Order
  • Descending Order
  • Multi-column Sorting

Limit & Offset

Control the number of records returned by the query.

Limit Maximum number of rows.
Offset Skip records before retrieval.

Available Actions

Action Description
Save Query Save query configuration.
Generate Query Automatically generate SQL.

Common Use Cases

List Views

Retrieve data for grid displays.

Dashboards

Feed charts and analytics.

APIs

Generate API datasets.

Workflows

Power workflow automation.

Best Practices

  • Use meaningful query names.
  • Optimize joins carefully.
  • Avoid SELECT * queries.
  • Use indexes where possible.
  • Document query purpose.
  • Test performance before deployment.