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
Compliant and Reliable File Transfers Backed by Top Security Certifications
Stop relying on non-certified, legacy file transfer tools that creak under the weight of modern security demands. Get full audit trails, advanced access controls and more supported by an award-winning team of experts. Start your free 25-day trial today.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of SPyQL!