Skip to content
| Marketplace
Sign in
Visual Studio Code>Programming Languages>Easy SQLNew to Visual Studio Code? Get it now.

Easy SQL

Easy SQL

|
191 installs
| (1) | Free
Language support for ETLs developed in Easy SQL. Includes syntax highlighting, code completion, usage doc, file jumpping and so on.
Installation
Launch VS Code Quick Open (Ctrl+P), paste the following command, and press enter.
Copied to clipboard
More Info

Easy SQL extension for Visual Studio Code

This is the VS code extension for Easy SQL. A bunch of language features are supported.

For ETLs written in Easy SQL, keywords, variable reference, template reference, function calls etc are highlighted. More information will be provided if we hover on keywords or functions.

When we're coding in Easy SQL, realtime keyword and function completions are provided as well.

And if there is some syntax error, diagnostic information will be provided.

Usage

Once installed in Visual Studio Code, the language feature will be enabled in every '.sql' file.

Highlight

An example of hightlight screenshot is as below:

Highlight screenshot

In order to make EasySQL related keyword more obvious, we can customize the colors a little. A recommended settings is as below:

{
  ...
  "editor.tokenColorCustomizations": {
    "textMateRules": [
      {
        "scope": "keyword.target, keyword.config, keyword.prepare-sql, keyword.include",
        "settings": {
          "fontStyle": "bold"
        }
      }
    ]
  }
  ...
}

We can add this configuration to user settings.json to make it work. (Open command palette, search for Open User Settings json, add the content above to the opened settings.json file.) This will make the keyword bold.

Code completion

An example usage of code completion is as below:

Code completion

Right now, keywords, functions completion will be provided.

Diagnostics information

An example usage of diagnostics is as below:

Diagnostics information

Right now, syntax error diagnostics will be provided.

More information on hover

An example usage of hover is as below:

Hover

Right now, keyword and function information are provided on hover.

Features

  • Hightlight keywords, function calls, variable reference, templates variables, template reference, conditional targets and other items in ETL.
  • Provide diagnostics information on syntax error.
  • Provide keyword/function completion when typing.
  • Provide more information when hover on keyword and functions.

Known Issues

  • Semantic analysis support: variable could be put anywhere in a function call
  • Semantic analysis support: template variable could be put anywhere in the template body

Release Notes

Language features for ETLs written in Easy SQL, including syntax highlight, code completion, syntax diagnostics, and hover for more information.

1.3.x

  • Jump to template definition
  • Jump to file (for include target)

1.2.x

Hover: provide more doc for python system functions

1.1.x

Diagnostics improved: provide diagnostics for target definition

1.0.x

Basic code completion, diagnostics, hover for more information implemented.

0.2.0

Syntax highlight based on semantic analysis result.

0.1.0

Syntax highlight.

Roadmap

  • Completion: provide variable/template/template-variable/include completion
  • Jump to definition: jump to template definition for included files
  • Jump to definition: jump to var definition in current file and in included files

For more information

  • Easy SQL
  • Easy SQL syntax

Enjoy!

  • Contact us
  • Jobs
  • Privacy
  • Terms of use
  • Trademarks
© 2023 Microsoft