How to work with SQL efficiently?

[frol]

If you need a UI to work with SQL, we recommend using DBeaver.

We chose to use uppercase for SQL keywords and here is how you can configure DBeaver:

1. Open "File" -> "Properties" in the navigation menu
2. Navigate to "Editors" -> "SQL Editor" -> "Formatting"

3. Click on "Global settings" in the top right corner
4. Set "Keyword case" to "Upper"

Tip: You may also want to disable "Insert table aliases (in FROM clause)" in the "Code Completion" section.