SPyQL (https://github.com/dcmoura/spyql) is SQL with Python in the middle, an open-source project fully written in Python for making command-line data processing more intuitive, readable and powerful. Try mixing in the same pot: a SQL SELECT for providing the structure, Python expressions for defining transformations and conditions, the essence of awk as a data-processing language, and the JSON handling capabilities of jq.
The Readme is loaded with recipes and there is also a demo video: https://vimeo.com/danielcmoura/spyqldemo
Any feedback is welcomed! Thank you.
reply