Introduction

Last updated 12/03/2026

Overview

The Query Builder in Five provides a visual, point-and-click interface for creating database queries without needing to manually write SQL. It allows you to construct queries by selecting tables and fields from the application's database and defining how the data should be returned.

Using the Query Builder, tables can be added to a query and their relationships are automatically displayed, making it easier to understand how data is connected. Fields can then be selected from each table to define the data that will be returned in the result set.

The builder also supports MySQL aggregate functions allowing you to perform calculations and summaries directly within the query. Criteria can be added to filter records, functioning in the same way as a

WHERE

clause in SQL, and aliases can be applied to fields or expressions to control how column names appear in query results.

When a query is created using the Query Builder, the corresponding SQL is automatically generated and inserted into the SQL editor. This makes the Query Builder a convenient way to quickly create the initial structure of a query, after which the SQL can be further refined or extended directly within the editor to support more advanced logic.