Is it possible to have source code SQL blocks that are processed with a custom command line tool? e.g. how can I make something like this to work:
#+begin_src sql :cmdline "osqueryi --json" select * from processes limit 5; #+end_src For those who don't know what osquery is, here's a quote from https://osquery.io: "Osquery uses basic SQL commands to leverage a relational data-model to describe a device." I vaguely remember there was a way to basically "pipe" entire code block to be executed in a given cmd line tool, but I am struggling to find how to do that. There's a way, right? But even then, I think it requires the code block to be of sh-mode of shell-mode, but I want it to be SQL because osquery uses SQL.