Query Builder
The Query Builder allows you to easily create and customize database queries without coding, using a simple interface to select tables, actions, and conditions.
Last updated
The Query Builder allows you to easily create and customize database queries without coding, using a simple interface to select tables, actions, and conditions.
Last updated
In this section, you can configure the table on which the query needs to be executed. You will see a list of all the tables created under the selected environment.
TThis section allows you to select the action type for the query, which could be SELECT
, UPDATE
, INSERT
, or DELETE
based on your needs:
SELECT: Used when you need to retrieve data from a table, potentially with specific columns.
INSERT: Used to insert a new entry into the table. You can configure this to fit the data you need to add.
UPDATE: Used to modify an existing entry in the table, typically for a specific item or based on a condition.
DELETE: Used to remove an entry from the table, either for a specific item or based on a condition.
This section is visible only when the SELECT query action type is chosen. It allows you to select which columns should be returned from the query. You can configure this section to specify only the data you want to retrieve
This section is used when configuring an INSERT
query. Here, you can select the columns that will receive values when a new entry is added to the table.
To add a column, click the Add button. You can configure the values for each selected column, and these values can also be dynamically sourced by clicking the plus (+) icon next to the input field. This will load the data source model, allowing you to pull in data from other sources or requests during execution.
This section is similar to the Insert Columns section but is used for UPDATE
queries. Here, you can specify the columns that need to be modified in an existing entry.
To add a column for updating, click the Add button. Configure the values for each selected column, which can also be dynamically sourced by clicking the plus (+) icon next to the input field. This will load the data source model, allowing you to pull in data from other sources or requests at the time of execution.
In this section, you can define the conditions under which the query should be executed.
For example, if you need to retrieve a user whose email is contact@fireapis.com
, you would configure the following:
Table: user
Query Action: SELECT
Select Columns: Choose which columns to return (e.g., name
, email
, etc.)
Condition: Set the condition to check if the email equals contact@fireapis.com
.
Dynamic values for the condition (e.g., the email) can be configured by clicking the plus (+) icon next to the input field. This will load the data source model, allowing you to pull dynamic data from the request or other sources when the logic is executed.
Below, we have added a few video explanations for your reference.