Skip to main content

Queries

Default actions allow users to perform create, read, update, and delete actions entity records. Queries enable developers to retrieve, manipulate, and combine data from multiple entities, perform calculations, and modify records as needed during application development. Once created, queries can be reused across multiple server flows, ensuring efficiency and consistency.

Query Commands​

Users can utilize the following commands to create queries accordingly:

CommandDescription
SELECTThe SELECT query retrieves data from a database. It allows you to specify which columns to retrieve and from which table. Conditions can be included to filter results. Users can also use functions to aggregate, sort, and join data as needed.
INSERTThe INSERT query is used to add new records or data entries to a database. It specifies the table where the new data should be inserted and provides the values for each column in the new record.
UPDATEThe UPDATE query modifies existing records in a database. It specifies the table to update, the columns to modify, and the new values to set. Similar to the SELECT query, it may include conditions to target specific records for updating.
DELETEThe DELETE query removes records from a database. It specifies the table from which records should be deleted and includes conditions to identify the records to be removed. Be cautious with this operation, as it permanently deletes data.