support strings start with more SQL keywords
It would be nice to support more keywords such as WHERE and use uppercase to avoid confusion. The use case would be for conditional query manipulation, e.g.
country_filter = "WHERE country = %s" if country else ""
query = f"""--sql
SELECT * FROM projects
{country_filter}
"""
Also AND OR
Example
let sql = "AND w.account_id = $2";
- Fork repo
- Update highlight-sql-string.json
- Delete previous version from extensions 3.1 Restart extensions (if vscode suggests)
- Rebuild extension
- Install new version
Fork repo, update highlight-sql-string.json, delete previous version from extensions, restart extensions (if vscode suggests), rebuild extension and install new version
How would you rebuild it? Tried packaging it with vsce but no luck.
Fork repo, update highlight-sql-string.json, delete previous version from extensions, restart extensions (if vscode suggests), rebuild extension and install new version
How would you rebuild it? Tried packaging it with
vscebut no luck.
I update engines in package.json to:
"engines": {
"vscode": "^1.88.0"
},
And use this command:
npx vsce package && code --install-extension inline-sql-syntax-2.16.0.vsix
My repo: https://github.com/gomez-git/inline_sql_syntax
I really like the changes made in that repo, thanks!
I had to change one of the esbuild params since I got an error that the "Extension entrypoint(s) missing." Changed to --outfile=out/extension.js and now it works fine.