Built-in SQL editor
The IOMETE SQL Editor allows you to effectively write and execute queries against your data using modern features and a clean, customizable UI.
The advanced Autocomplete function removes the need to remember the SQL syntax. It makes proactive suggestions while you type, using the built-in data catalog.
The Schema Explorer allows you to explore the schema of your databases while writing your query. Make use of the metadata for entities. Get shortcuts for the standard queries with the context menu and insert them into the current worksheet with a click. Copy the names of entities with a keyboard combination.
Save your queries and return back to them whenever you want and with the autosave feature you don’t have to worry about losing any progress.
Navigate through previous steps, check the metadata of the query, and reuse the query by opening it in the current worksheet.
Create Query Variables and use them throughout your worksheets. Safely change the value of a variable from one place without the necessity to edit the query.
Hide sections or make them full screen if you need to concentrate on something particular. Place your results at the right or go with the default placement at the bottom. With a clean and intuitive UI there is no need to worry about getting uncomfortable with a lot of elements on the screen. Everything is scrollable and manageable.