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

Project Samples

Project Activity

See All Activity >

Categories

JSON

License

MIT License

Follow SPyQL

SPyQL Web Site

Other Useful Business Software
Compliant and Reliable File Transfers Backed by Top Security Certifications Icon
Compliant and Reliable File Transfers Backed by Top Security Certifications

Cerberus FTP Server delivers SOC 2 Type II certified security and FIPS 140-2 validated encryption.

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.
Start Free Trial
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of SPyQL!

Additional Project Details

Programming Language

Python

Related Categories

Python JSON Software

Registered

2023-10-17