From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id YPXLC2At6V4lSAAA0tVLHw (envelope-from ) for ; Tue, 16 Jun 2020 20:36:48 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id cCq4B2At6V7KbQAAbx9fmQ (envelope-from ) for ; Tue, 16 Jun 2020 20:36:48 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 7DA7C9404CB for ; Tue, 16 Jun 2020 20:36:47 +0000 (UTC) Received: from localhost ([::1]:42574 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1jlIK5-00066y-Rq for larch@yhetil.org; Tue, 16 Jun 2020 16:36:45 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58872) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1jlIJG-0005ZH-IN for emacs-orgmode@gnu.org; Tue, 16 Jun 2020 16:35:54 -0400 Received: from mail-pg1-x52d.google.com ([2607:f8b0:4864:20::52d]:35245) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1jlIJE-0008V5-UT for emacs-orgmode@gnu.org; Tue, 16 Jun 2020 16:35:54 -0400 Received: by mail-pg1-x52d.google.com with SMTP id s135so109288pgs.2 for ; Tue, 16 Jun 2020 13:35:52 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=sender:user-agent:from:to:subject:message-id:date:mime-version; bh=gg8YUCZDUOyVMJr7gxadICr30gf8o5KZsRd/aWKSeak=; b=qP0YvdjK/TRs+8uizlRbreFTr46/uFjmDd0L3qflSaWEwtydA2IGrGt6rnp8634Too dj/gvo7N12H2paXE0l9AnK0NkR7MZESXgU1ZuLAy9nUydmpeeSMO0ZP49yZPOZ011QYn xdkcYyWWCSWgWZaykZ3Pv38N86kxRCIgM67Gp+n5a67Ib762qEvKl6CjDz4xYl9JnXQM zrVZuiPzqJ5PNIa9iZQVdx0zVygoKxtPHIvy8FgpCtaMzG8/Y8KvLv+BroKtSBLde98/ bss3xR9jjmZc3IQmH73S0/BiyNUHxpV8GEOiCS1Vhk3WuwTU6ZXkm6QO3iUI9smh4sIK /hXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:sender:user-agent:from:to:subject:message-id :date:mime-version; bh=gg8YUCZDUOyVMJr7gxadICr30gf8o5KZsRd/aWKSeak=; b=DdY6l8JVrBlAs7CyvwBgD6gFC/ejkBwTVpwRU1r07nZ4EPZmPABiOXSxie2AfcnLyO eH9mLf6hMeL7xAmrCavOBYs2To7oJomkXNIv37HF0A3V21gbJnHwk1BDoplhlxBCDgZC 8MCeu7YEbtJJm8BTKS5caI2f7iyL2R+eaE/t20qZn5E9YhaerzUHFqqk80WqveHWOUsS RZM4bikEoRk7IkNRxIvWqoE7xhpUFfL5YGdwbiYpE02HG96sNJRgZxZU8jQFHDVWkpE8 UzVPti2Zhdq3+VWqbRHHVJ3dtPIUpJ4bnAQEzwfy6Ebo20MMZTJZz7JIHBvA8CUdrx55 7ulg== X-Gm-Message-State: AOAM531afejnLCU5bnNiMX4HA3fP9Xsz4Jovb4xob8syUtotLE161rAK ln0vgaKB8Z3asxXXflJ5vjOMSbLHBzk= X-Google-Smtp-Source: ABdhPJxqvhqz60R/F+WDR1giN1osAHiWiBAtHTuNo4DCZ1fwJVI13P3mc3oIIgZMGrEUdG335VQObA== X-Received: by 2002:a63:2104:: with SMTP id h4mr3546315pgh.427.1592339750727; Tue, 16 Jun 2020 13:35:50 -0700 (PDT) Received: from AIBRAGIM-M-J8Z8 (c-73-170-229-122.hsd1.ca.comcast.net. [73.170.229.122]) by smtp.gmail.com with ESMTPSA id k101sm3473229pjb.26.2020.06.16.13.35.49 for (version=TLS1_2 cipher=ECDHE-ECDSA-CHACHA20-POLY1305 bits=256/256); Tue, 16 Jun 2020 13:35:50 -0700 (PDT) User-agent: mu4e 1.4.10; emacs 28.0.50 From: Ag Ibragimov To: emacs-orgmode@gnu.org Subject: ob-sql src blocks with a totally custom engine Message-ID: Date: Tue, 16 Jun 2020 13:35:48 -0700 MIME-Version: 1.0 Content-Type: text/plain; format=flowed Received-SPF: pass client-ip=2607:f8b0:4864:20::52d; envelope-from=agzam.ibragimov@gmail.com; helo=mail-pg1-x52d.google.com X-detected-operating-system: by eggs.gnu.org: No matching host in p0f cache. That's all we know. X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001 autolearn=_AUTOLEARN X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=fail (rsa verify failed) header.d=gmail.com header.s=20161025 header.b=qP0YvdjK; dmarc=fail reason="SPF not aligned (relaxed)" header.from=gmail.com (policy=none); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Spam-Score: 0.09 X-TUID: zjYpgLri7GiB 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.