JSQLON

Write SQL, read JSON.

Usage

$ jsqlon <JDBC connection string>

Write JSON-wrapped SQL to STDIN. Read JSON from STDOUT.

For example, with a PostgreSQL table named people with four columns:

• id INT
• name TEXT
• dob DATE
• meta JSON

$ jsqlon 'postgresql://localhost/people?user=me&password=knockknock&stringtype=unspecified'
{"query": "SELECT * FROM people WHERE dob < ?", parameters: ["1980-01-01"]}
{
  "success": true,
  "results: [
    {"id": 1, "name": "Alice", "dob": "1978-02-01", "meta": null},
    {"id": 2, "name": "Bob",   "dob": "1978-02-01", "meta": {"talks-to": "Alice", "height": 187}}
  ]
}

License

This software is licensed under the GNU General Public License, version 3.