Support `${workspaceFolder}` variable in sqltools.sessionFilesFolder setting

[pztrn]

Is your feature request related to a problem? Please describe. I have .vscode in .gitignore file and want to save session file there. Currently the only option is to specify absolute path to that directory, which actually not an option and would break if I move project somewhere else.

Describe the solution you'd like Support ${workspaceFolder} variable in sqltools.sessionFilesFolder setting so I can save sassion file somewhere in workspace directory without specifying absolute path.

Describe alternatives you've considered Specifying absolute path.

Additional context Using latest available sqltools (0.25.1) in vscode (1.72.1).

Current behavior:

• ${workspaceFolder}/.vscode - trying to create $\{workspaceFolder\}/.vscode and fails to save session file.
• .vscode - trying to create /.vscode and fails to save session file.

[Novocastrian]

+1 for this support. The current experience isn't back-breaking as long as you delete the file before your following git commit/whatever. Still, there is the added risk that queries using sensitive data will appear in the git history for that repo if you forget to remove the sensitive data before committing.

My current workaround is to move the queries manually I do want to keep into a queries/adhoc folder, and delete those that I don't need records of before doing anything with git.