SQL with Python in the middle. SPyQL is a query language that combines the simplicity and structure of SQL with the power and readability of Python. SPyQL offers a command-line interface that allows running SPyQL queries on top of text data (e.g. CSV, JSON). Data can come from files but also from data streams, such as as Kafka, or from databases such as PostgreSQL. Basically, data can come from any command that outputs text :-). More, data can be generated by a Python expression! And since SPyQL also writes to different formats, it allows to easily convert between data formats.
Features
- SQL provides the structure of the query
- SPyQL is fast and memory efficient
- SPyQL offers a command-line interface that allows running SPyQL queries on top of text data
- SPyQL also writes to different formats, it allows to easily convert between data formats
- SPyQL is also available as a Python module
- Natural support for lists, sets, dictionaries, objects, etc
Categories
JSONLicense
MIT LicenseFollow SPyQL
Other Useful Business Software
The full-stack observability platform that protects your dataLayer, tags and conversion data
Code-Cube.io detects issues instantly, alerts you in real time and helps you resolve them fast.
No manual QA. No unreliable data. Just data you can trust and act on.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SPyQL!