# SQL SQL in blup is similar to a traditional SQL editor in the sense, that in SQL you can manage, and edit your SQL queries and, through SQL query you can modify data from the tables present in Sheets. The SQL consists of mainly 3 sections: * **SQL Queries View** * **SQL Bar** * **SQL Editor**

### **SQL Queries View** **SQL Queries View** consists of all **SQL** **Queries** that you have created. This mainly consists of three columns, the **Name** of the query, the **Description** of the query, and the **Last Modified** date of the query. You can select any query by checking the check box on the left side of each query entry and perform operations like edit or delete. This View helps in managing all SQL queries you have made, this can come in handy if you have a large project.

### SQL Bar The **SQL Bar** includes several buttons designed to help you efficiently manage SQL queries. These buttons serve various purposes, such as refreshing all queries and editing query details. Let’s explore them one by one! 😊

**Refresh Button** This button is used to refresh all SQL queries.

#### **Search Button** On enabling this button, a search bar will appear below the **Name**, **Description,** and **Last Modified** of your queries. The SQL queries are stored in a table which is explained below, so that you can search a query based on the **Name or** **Description or Last Modified** that you provide in the search bar.

#### **Add Query Button** **The Add Query Button** is used to create a new query. On clicking this button a pop-up will appear asking you to enter the **Name** and **Description** of the query which you want to make. This is done so that you can manage different queries and keep track of what the particular query does in writing the description.

#### **Delete Query Button** **The Delete Query** button is used to delete a query, this button is disabled by default if no query is selected or present. Firstly, select a query to delete it.

> Note: You can also delete multiple queries by selecting them. #### **Edit Query Button** **The Edit Query** button is used to edit a query, the **Edit Query** is disabled by default if no query is selected. On clicking **Edit Query,** a pop-up will appear containing the **Name** and **Description** of the query that you can edit and save.

#### **Filter Button** On enabling the **Filter Button**, a filter option will appear on the right side of all the columns present in the **SQL Queries View**, where you can apply the filters on the data present. There are some filter options like: * A-Z / Z-A for Text-type columns - sort by ascending or descending for text * Newest First / Oldest First for Date Time type columns - sort by datetime.

**SQL Editor** The **SQL Editor** is one of the most important parts of the SQL section. Here you can write your SQL queries and test them. The query that you have clicked from the SQL query table is shown here.

The SQL Editor has mainly 4 parts: ### **1.** SQL Editor **Top Bar** The top bar consists of three things : 1\) **SQL Query Name** - Name of the query that is opened. 2\) **Run SQL Button** - This is used to run the SQL query, along with this you can also configure a test event by clicking the dropdown arrow from the Run SQL button. 3\) **Save SQL Button** - This is used to save an edited SQL query, you need to run the query or press this button in order to save the query you have written.

### ***2. Editor*** Here you can write your SQL queries, this works as a traditional code editor where you can copy, cut, and paste your code along with SQL syntax highlighting

### ***3. QT AI Prompt Bar*** The SQL section has an AI-powered editor called QT AI, where you can write a prompt and the respective SQL query will be generated for you. For example, you can give a prompt "Give me all the phone numbers from the user table", it AI automatically recognizes the context and gives you a SELECT query.

### ***4. Output Section*** This is where you get the execution results of your sql query, it shows you the error encountered if any, or the success result obtained from running the query.

## Music to go with. {% embed url="" %} Lofi music {% endembed %}