Support for Interpolated Variables from Connections Config

[lucasvieirasilva]

This PR adds support for interpolated variables from the connection config.

Example:

{
  "sqltools.queryParams.enableReplace": true,
  "sqltools.connections": [
    {
      "name": "SQLite",
      "driver": "SQLite",
      "database": "./docker/sqlite/test_db.db",
      "connectionTimeout": 15,
      "variables": {
        "env": "dev"
      }
    }
  ]
}

Query:

SELECT * FROM table_$[env];

You can also use Jinja format by adding the sqltools.queryParams.regex property with this value \\{\\{(.*)\\}\\}

Query:

SELECT * FROM table_{{ env }};

Benefits

Using pre-defined variables from the connection config to avoid prompting the variable value every time the user runs the query.

Related Issues

• 744

---

Thank you for your contribution! Before submitting this PR, please make sure:

• [x] Your code builds clean without any errors or warnings
• [x] You have made the needed changes to the docs
• [x] You have written a description of what is the purpose of this pull request above

[lucasvieirasilva]

Thanks for this contribution. I have suggested a minor change to a description in two places. Then I think it will be ready to merge.

@gjsjohnmurray Thanks for the review, I've applied your suggestions