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.
+ button on the top-left.
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.
Go to the right sidebar, and name the query
Example Query to save it and find it easily in the future.