Query Editor (Reference) provides SQL script writing capabilities with syntax highlighting, auto-completion, and advanced text manipulation features. The Query Editor enables:
- SQL syntax highlighting
- Auto-completion support
- Search and replace
- Code formatting
- Whitespace management
- Visual customization
Access via double-clicking SqlStatement in Dataset Queries or through the dedicated editor button.
Edit Actions
Basic Operations
| Action | Shortcut | Description |
|---|---|---|
| Undo | Ctrl+Z | Revert last action |
| Redo | Ctrl+Y | Reapply undone action |
| Cut | Ctrl+X | Remove and copy to clipboard |
| Copy | Ctrl+C | Copy to clipboard |
| Paste | Ctrl+V | Insert from clipboard |
| Delete | Delete | Remove without copying |
| Select All | Ctrl+A | Highlight entire content |
Advanced Operations
| Action | Description |
|---|---|
| Cut/Append | Cut and append to existing clipboard |
| Copy/Append | Copy and append to existing clipboard |
| Insert Example | Insert predefined SQL template |
| Is Document Read-only | Check edit permissions |
Search Functions
| Function | Shortcut | Description |
|---|---|---|
| Find | Ctrl+F | Open search dialog |
| Find Next | F3 | Next occurrence |
| Incremental Search | Ctrl+I | Search while typing |
View Options
Margin Controls
| Option | Purpose |
|---|---|
| Indicator Margin | Error/warning indicators |
| Line Number Margin | Line numbering display |
| Outlining Margin | Code folding controls |
| Ruler Margin | Horizontal ruler |
| Selection Margin | Click-to-select lines |
Display Settings
| Option | Purpose |
|---|---|
| Word Wrap | Wrap long lines |
| Word Wrap Glyphs | Show wrap indicators |
| Whitespace Visible | Display spaces/tabs |
| Indentation Guides | Vertical indent lines |
| Line Modification Marks | Show changed lines |
Highlighting Options
| Option | Purpose |
|---|---|
| Current Line Highlighting | Highlight cursor line |
| Delimiter Highlighting | Match brackets/parentheses |
| Search Result Highlighting | Highlight found text |
Navigation Settings
| Option | Purpose |
|---|---|
| Can Scroll Past Document End | Allow scrolling beyond text |
| Virtual Space at Line End | Cursor beyond line end |
| Auto-Correct Enabled | Automatic corrections |
| Toggle Token Info in Status Bar | SQL token information |
Advanced Options
Whitespace Management
| Operation | Description |
|---|---|
| Convert Tabs to Spaces | Replace tabs with spaces |
| Convert Spaces to Tabs | Replace spaces with tabs |
| Tabify Selected Lines | Leading spaces to tabs |
| Untabify Selected Lines | Leading tabs to spaces |
| Delete Horizontal Whitespace | Remove inline spaces |
| Trim All Trailing Whitespace | Clean all line endings |
| Trim Trailing Whitespace | Clean selected lines |
| Delete Blank Lines | Remove empty lines |
Text Transformation
| Operation | Description |
|---|---|
| Make Uppercase | Convert to UPPER |
| Make Lowercase | Convert to lower |
| Toggle Character Casing | Switch case |
| Capitalize | First Letter Caps |
SQL Features
Syntax Highlighting
- Keywords (SELECT, FROM, WHERE)
- Functions (COUNT, SUM, AVG)
- Strings and numbers
- Comments (-- and /* */)
- Tag placeholders {{Tag.Name}}
Auto-Completion
- SQL keywords
- Table names
- Column names
- Function names
- Tag references
Code Templates
Common SQL patterns:
sql
-- Basic SELECT
SELECT * FROM TableName WHERE Condition
-- JOIN template
SELECT t1.*, t2.*
FROM Table1 t1
INNER JOIN Table2 t2 ON t1.ID = t2.ID
-- INSERT with tags
INSERT INTO TableName (Col1, Col2)
VALUES ({{Tag.Value1}}, {{Tag.Value2}})Keyboard Shortcuts
Navigation
| Shortcut | Action |
|---|---|
| Home | Line start |
| End | Line end |
| Ctrl+Home | Document start |
| Ctrl+End | Document end |
| Ctrl+G | Go to line |
Selection
| Shortcut | Action |
|---|---|
| Shift+Arrow | Extend selection |
| Ctrl+Shift+Arrow | Word selection |
| Shift+Home/End | Line selection |
| Ctrl+L | Select line |
Editing
| Shortcut | Action |
|---|---|
| Tab | Indent |
| Shift+Tab | Outdent |
| Ctrl+] | Increase indent |
| Ctrl+[ | Decrease indent |
Best Practices Checklist
- Enable line numbers - Easy reference
- Show whitespace - Spot formatting issues
- Use delimiter highlighting - Match parentheses
- Enable word wrap - Long queries visible
- Regular formatting - Consistent indentation
- Trim whitespace - Clean code
- Use templates - Standard patterns
Tips and Tricks
Efficient Editing
- Use incremental search for quick navigation
- Cut/Append for building complex queries
- Multi-line selection with Alt+drag
Code Organization
- Fold complex subqueries
- Use consistent indentation
- Comment complex logic
- Group related statements
Performance
- Highlight slow query patterns
- Use execution plan preview
- Monitor token complexity
In this section...