Making a Query

Create a table. Insert, read, update, and delete data.

Queries allow you to display or modify data from databases. Because your components are powered by queries, your internal applications can read and write data to databases as well.

You can connect components to queries by their properties. For instance, you can set a slider to update the value of a row in your database to the number of the slider.

To Create a Query Tab:

  • Click the + button on the top-left.

  • Then chose Query.

Execute a Query

To execute a query, write SQL in the SQL Editor and then either click RUN or use the shortcut cmd + Enter

To write and execute multiple queries, separate them with a semicolon.

To execute a single query among many in the same editor, highlight the query you want to run and click RUN. The rest of your editor will be ignored, and only the highlighted section with be executed.

Once you have executed a query, click Expand Results if you want to see the result grid in full view.

Notice the Result Grid directly below the SQL Editor displays the results.

Name Your Query to Save It

Go to the right sidebar, and name the query Example Query to save it and find it easily in the future.