SQL Query Console
Run SQL with autocomplete, a results grid, cell editing, UPDATE/DELETE generation, history, filter, sort, and CSV export.
The Query Console is the core workspace in OL DataIQ for writing, running, and working with SQL against any configured connection.
Capabilities
Editor & execution
- Multi-line SQL editor with syntax-aware autocomplete (keywords, tables, columns)
- Quick table selection generates
SELECT * FROM table - Execution time, row count, and scrollable tabular results
- Highlight one statement in a longer script and the console runs only that selection. The button changes to Execute Selection. With nothing selected, the whole editor runs as before. Sorting, filtering, paging, Save Query, and Create API use the statement that ran. The other statements stay in the editor