Run steampipe, osquery, and other SQL CLI wrappers?

cmoog / vscode-sql-notebook

Open SQL files as VSCode Notebooks.

https://marketplace.visualstudio.com/items?itemName=cmoog.sqlnotebook

MIT License

129 stars 18 forks source link

Run steampipe, osquery, and other SQL CLI wrappers? #61

Closed shah closed 1 year ago

shah commented 1 year ago

@cmoog thanks again for this fantastic VS Code extension! I've been using steampipe, osquery, and other "SQL CLI wrappers" (tools which pass in SQL and return results as STDOUT).

I was curious if you've thought about creating settings / configuration options to allow SQL to be passed into arbitrary CLIs?

Reference:

Thanks!

cmoog commented 1 year ago

Interesting suggestion– those look like cool projects. For now, I don't think this could fit cleanly inside vscode-sql-notebook as it would likely be a leaky abstraction. For instance some complications without easy answers

would the CLI output be parsed into the same tabular output as all the other drivers? how about errors?
do we now need to off new configuration options for "CLI drivers", (env, args, working_dir, etc.)

That said, I could see a usefulness for a new, separate extension focused singularly on a CLI-based transformation of cell values into arbitrary output. But, I don't think it fits into the proper scope of vscode-sql-notebook.