PartiQL-rs

WIP

What's PartiQL?

partiql-cli

Installation

brew install fuyutarow/tap/partiql-cli

Usage

partiql-cli sql

Using SQL to select data from JSON.

sql=$(cat << EOS
SELECT e.id,
       e.name AS employeeName,
       e.title AS title
FROM hr.employees e
WHERE e.title = 'Dev Mgr'
EOS
)
partiql-cli sql -q "$sql" -f samples/q1.json -t json | jq

[
  {
    "id": 4,
    "employeeName": "Susan Smith",
    "title": "Dev Mgr"
  }
]

partiql-cli from

Convert PartiQL-IR <--> JSON.

This is a PartiQL-IR.

$ cat samples/q1.env
{ 
    'hr': { 
        'employees': <<
            -- a tuple is denoted by { ... } in the PartiQL data model
            { 'id': 3, 'name': 'Bob Smith',   'title': null }, 
            { 'id': 4, 'name': 'Susan Smith', 'title': 'Dev Mgr' },
            { 'id': 6, 'name': 'Jane Smith',  'title': 'Software Eng 2'}
        >>
    }
} 

PartiQL-IR --> JSON

cat samples/q1.env | partiql-cli from --to json | jq

{
  "hr": {
    "employees": [
      {
        "name": "Bob Smith",
        "title": null,
        "id": 3
      },
      {
        "name": "Susan Smith",
        "title": "Dev Mgr",
        "id": 4
      },
      {
        "name": "Jane Smith",
        "id": 6,
        "title": "Software Eng 2"
      }
    ]
  }
}

PartiQL-IR --> JSON --> PartiQL-IR

cat samples/q1.env | partiql-cli from --to json | partiql-cli from --to partiql