Kappe

Kappe is a tool designed to compile SQL to Elasticsearch’s JSON-based query syntax. Currently, the featureset is small, basic SELECT a, b, c FROM d WHERE e = "f" queries work. Output is printed to STDOUT where it can be collected onto the clipboard or into a file for later use.

Installation

Install Rust if you don’t have it already.

$ curl --proto '=https' --tlsv1.2 -sSf https://sh.rustup.rs | sh

Once you have Rust installed, you can use Cargo to install Kappe.

$ git clone https://git.simulacrum.party/simulacrumparty/kappe
$ cd kappe
$ cargo install --path .

Usage

$ kappe 'select a, b, c from d where e = f'
GET /documents/_search
{
  "_source": [
    "a",
    "b",
    "c"
  ],
  "query": {
    "bool": {
      "filter": [
        {
          "term": {
            "e": "f"
          }
        }
      ]
    }
  }
}