Writing SQL is such a fundamental part of interacting with a relational database that we put this functionality front and center.
You can use the SQL query tab to write, and run, SQL queries quickly and easily.
Code completion
We have tried to make our code completion useful but not intrusive.
Code suggestions will automatically appear in the following situations:
tables
will be suggested after typingfrom
orjoin
columns
will be suggested after typing a tablename, or table alias, followed by a period, egfilm.
In these situations, Beekeeper will automatically resolve the correct table and column names for the entity you are querying.
Manually triggering autocomplete
The default key combo to manually trigger autocomplete is Ctrl+Space
, or Cmd+Space
for MacOS users.
Run Contexts
If you like writing big long SQL scripts with multiple queries in the same editor pane (I know I do), you might want to only run a portion of your script at a time.
Beekeeper allows you to:
- Run everything (this is the default)
- Run only the ‘current’ query (Beekeeper highlights this query for you so you know what will run)
- Run only what you have selected.
Query Parameters
You can parameterize your queries and Beekeeper will prompt you for values when you run it.
You can use three types of syntax :variable
, $1
, or ?
depending on the database engine you are querying.
select * from table where foo = :one and bar = :two
select * from table where foo = $1 and bar = $2