jsonsql

For package maintainers and hackage trustees Interpolates JSON data into SQL strings from the command line. For generating SQL statements to pass to DB client programs like psql, mysql, and sqlite3 via Unix pipelines or shell scripts. A faster, lighter-weight alternative to writing ad-hoc, monolithic programs with database and ORM libraries. A template file with this interpolation syntax: combined with this JSON stream on STDIN generates this output: If a key path evaluates to an array of values, specify a <delimiter> to have the the values converted into strings, joined by the delimiter, and then output as a string. If a key path terminates in a JSON object or array (without a array delimiter specified), a JSON literal will be interpolated: template: output: To interpolate the base object as a literal JSON string, use :. as the keypath. Do NOT put quotes around the placeholder for a literal JSON interpolation.