Query editor and designer

Edit SQL queries, or use query designer

Query editor and designer

  • Syntax highlighting
  • Code completion
  • Join wizard - add SQL joins effectively
  • SQL formatter
  • Save to “Saved queries” tab, or save to disk

Query designer

  • Design query on tables and views
  • Join types:
    • INNER JOIN
    • LEFT JOIN
    • RIGHT JOIN
    • FULL OUTER JOIN
    • CROSS JOIN
    • WHERE EXISTS (SEMI JOIN)
    • WHERE NOT EXISTS (ANTI SEMI JOIN)
  • GROUP BY, aggregate functions
  • Filters
  • Ordering

These links points to demo.dbgate.org, feel free to play with it

Query editor

SQL join wizard

Query designer